What are the steps you will take to improve performance of a poor performing query?

1 Answers   HCL,

---

What is transaction server explicit transaction?

0 Answers  

---

How do I find the sql server instance name?

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,

---

Which autogrowth database setting is good?

0 Answers  

---

---

What is the sql server 2000 version number?

0 Answers  

---

What new changes are being made in SQL Server?

0 Answers   Blue Star,

---

write a query to remove duplicate records without using primary key column?

2 Answers   ABCO,

---

Find top Nth employee from each department in terms of salary?

13 Answers   RealPage,

---

Does order by actually change the order of the data in the tables or does it just change the output?

0 Answers  

---

What are the different types of indexes?

0 Answers   Blue Star,

---

How to link up the text file to a Database table?

2 Answers   Allianz,

---