Explain the architecture of ms sql reporting service?

936

---

What is lock escalation and what is its purpose?

992

---

Explain syntax for dropping triggers?

942

---

Explain datetimeoffset data type in sal server 2008?

925

---

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?

968

---

Explain concepts of analysis services?

975

---

Explain where clause?

1005

---

What are the advantages of sql stored procedure?

1094

---

Explain syntax for disabling triggers?

1052

---