What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning

3 Answers   TCS,

---

Explain the difference between delete,drop and truncate in SQL Server?

0 Answers   HCL,

---

Using the customer, and order table in northwind database, please write a query to produce xml?

0 Answers  

---

Can Somebody tell me the difference between Clustered & Non- Clustered Index??

5 Answers   Progressive,

---

What is the difference between a stored procedure and a user defined function in sql server?

2 Answers   Millennium,

---

---

How to implement service broker?

0 Answers  

---

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

1 Answers  

---

Which is better statement or preparedstatement?

0 Answers  

---

Explain basic SQL queries with SELECT from where Order By, Group By-Having?

3 Answers   TetraSoft, Wipro,

---

What are the difference between primary key and unique key? : sql server database administration

0 Answers  

---

Give main differences between "Truncate" and "Delete".

0 Answers   HCL,

---

What is Sqlpaging in SqlServer 2005 ?

0 Answers   MCN Solutions,

---