What is blocking and how would you troubleshoot it?

3 Answers   HCL,

---

How to Handle the exceptions in Sqlsrver 2005??

3 Answers   Value Labs, Wipro,

---

Explain the phases a transaction has to undergo?

0 Answers  

---

In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;

5 Answers   Infosys,

---

There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"

2 Answers  

---

What are the new security features added in sql server 2012? : sql server security

0 Answers  

---

What does it mean to manipulate data?

0 Answers  

---

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

0 Answers  

---

What is a Linked Server?

1 Answers  

---

explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

0 Answers   ADP, iSoft,

---

Why people hate cursor?

0 Answers  

---

What is row_number () and partition by in sql server?

0 Answers  

---