could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh

3 Answers  

---

Difference between LEN() and DATALENGTH() in sql server ?

0 Answers   HCL,

---

What is the default schema of your login session in ms sql server?

0 Answers  

---

How to a Query to copy data from on table to another table.

6 Answers   Cap Gemini,

---

What are the restrictions that views have to follow?

0 Answers  

---

---

What does asynchronous call backs means?

0 Answers   Alcatel-Lucent,

---

Explain what is lock escalation?

0 Answers  

---

What does REVERT do in SQL Server 2005?

0 Answers   HCL,

---

What protocol does sql server use?

0 Answers  

---

What are mdf,ndf,ldf files and how to see the data in those files?

6 Answers   Accenture,

---

Explain filtered indexes benefits?

0 Answers  

---

How reterive duplicate value in SQL?

6 Answers  

---