OPTIMIZATION OF SP,CURSOR,TRIGGERS

0 Answers  

---

What is a trace frag?

0 Answers  

---

What is the concept of optimization?

0 Answers  

---

Is null vs coalesce?

0 Answers  

---

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

0 Answers  

---

---

What are the basic functions for master, msdb, model, tempdb databases?

0 Answers  

---

When would you use it?

0 Answers  

---

code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

0 Answers   IGT,

---

Does index speed up select statements?

0 Answers  

---

How can you start sql server in different modes?

0 Answers  

---

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

0 Answers   QuestPond,

---

Describe and explain about SQL native client?

0 Answers  

---