What are statistics, under what circumstances they go out of date, how do you update them?

2 Answers   HCL,

---

What is the appropriate number of test cases that you can write on a database?

2 Answers   Microsoft,

---

What is Query Execution Plan? How does it help optimize or tune a database driven application?

2 Answers   Accenture, Polaris,

---

When should you use an instead of trigger?

0 Answers  

---

How to create and drop temp table in sql server?

0 Answers  

---

---

how to delete duplicate rows from table

9 Answers   CSC,

---

What is 'write-ahead log' in sql server 2000 ?

0 Answers  

---

What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.

3 Answers   247Customer,

---

what command is used to create a table by copying the structure of another table?

7 Answers  

---

Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,

---

Define tempdb database?

0 Answers  

---

in how many ways we can use count()

2 Answers  

---