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.

how can i lock the column in the table

2 Answers   Accenture,

---

Which is best Subquery (or) joins in sql server? explain why

2 Answers  

---

Accidentally i deleted my table. How can i get that table?

4 Answers  

---

How to select an exiting database using mssql_select_db()?

0 Answers  

---

How will u test the stroded procedures and functions? difference between SP and Triggers

2 Answers   TCS,

---

How To delete duplicate record from a particular table?

12 Answers   eXensys, Foxfire,

---

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

0 Answers  

---

What are different backups available in sql server?

0 Answers  

---

What is the difference between Drop and Truncate

20 Answers   GT Nexus, IBM,

---

what is the sql equivaent of the dataset relation object ?

0 Answers  

---

Which command is used for user defined error messages?

0 Answers  

---

What is the use of Port no?

1 Answers   Wipro,

---