Explain some DBCC commands?

6 Answers  

---

how to avoid cursors? : Sql server database administration

0 Answers  

---

Define full outer join?

0 Answers  

---

How To Change Column Ordinal Position in SQL Server 2005 using Query i.e I Want To Add Column at Particular Ordinal Position in SQL Server 2005

2 Answers  

---

Difference between drill down and drill through report.

0 Answers  

---

---

how can u select the Distinct values in the table, table having 20 columns , i want all columns

2 Answers  

---

Please explain what is “asynchronous” communication in sql server service broker?

0 Answers  

---

employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 Answers  

---

Explain trigger and its types?

0 Answers  

---

What are the steps to take to improve performance of a poor performing query? : sql server database administration

0 Answers  

---

Explain log shipping?

0 Answers  

---

Can you pass expressions to function parameters?

0 Answers  

---