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

1 Answers  

---

What is bcp? When does it used?

0 Answers  

---

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

2 Answers   Accenture, Polaris,

---

how can i view structure of table in sql server? tell me that query.

10 Answers  

---

About types of indexes in SQL server ?

2 Answers   Cognizant,

---

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

0 Answers   Facebook,

---

can we call functions from stored procedure in SQL Server 2005 ? How?

3 Answers  

---

Write the Syntax for Cursors.

2 Answers   CarrizalSoft Technologies, HP,

---

Why use “nolock” in sql server?

0 Answers  

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

---

How to rebuild all indexes on a single table?

0 Answers  

---

Define inner join? Explain with an example?

0 Answers  

---