Answer / gunjan sapra

fill factor is a defiened percentage between 0 to 100 in
which we leave exra gaps to accomodate future expansions in
the storage of the futures data.
indexing in sql is same as the index in our books. it helps
us to manage our data more appropriately.it can be done in
two ways namely clustered index and non-clusterd index.
we can create only one clustered index per table and
maximum of 249 non-clustered indexes per table.

What is optimization and its types?

0 Answers  

---

What does the INSTEAD OF trigger do?

3 Answers  

---

Why we need to use secondry database file? though, we can do same work using primary database file also.

2 Answers   Microsoft,

---

Define candidate key, alternate key, and composite key.

0 Answers  

---

How many triggers are possible per table?

0 Answers  

---

What is the difference between commit and rollback?

0 Answers  

---

How can sql injection be stopped? : sql server security

0 Answers  

---

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

0 Answers   Global Logic,

---

What are the differences between ms sql server & oracle?

0 Answers  

---

Explain what are the basic functions for master, msdb, model, tempdb databases?

0 Answers  

---

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

0 Answers  

---

What is WITH CHECK OPTION

3 Answers   Karur Vysya Bank KVB,

---