Define tool Manage Statistics in SQL Server 2000 query ?

0 Answers   NA,

---

Explain what is analysis service repository?

0 Answers  

---

Differencr Between DELETE and TRUNCATE?

3 Answers   ADP,

---

Why should we go for stored procedures? Why not direct queries?

0 Answers  

---

Explain an incremental backup?

0 Answers  

---

---

what is difference between having and where clause ?

3 Answers  

---

select the 3rd maximum salary from sql server database if 4 (just an example In practically I may not know the exact situation) of the highest salaries are equal.

8 Answers   TCS,

---

How to find out name of all employees who has salary less than 200 Rs.?

8 Answers  

---

how to find number of columns in a table in sql server 2000 and 2005 also

16 Answers   Virtusa,

---

Where the sql logs gets stored? : sql server database administration

0 Answers  

---

How can change procedure in sql server?

0 Answers  

---

What are the different methods available under sqlcommand class to access the data?

0 Answers   UGC Corporation,

---