Explain the difference between function and stored procedure?

959

---

Explain the architecture of ms sql reporting service?

936

---

What is lock escalation and what is its purpose?

994

---

Explain syntax for dropping triggers?

944

---

Explain datetimeoffset data type in sal server 2008?

926

---

What is buffer cash in sql server?

1165

---

Define master database?

1085

---

Explain transaction server auto commit?

1051

---

What are the essential components of sql server service broker?

1035

---

Why do we use non clustered index?

1099

---

How to use the inserted and deleted pseudo tables?

975

---

Define full outer join?

969

---

Explain concepts of analysis services?

975

---

Explain where clause?

1007

---

What are the advantages of sql stored procedure?

1094

---