What are the components of sql server service broker?

1031

---

Tell me what are the essential components of sql server service broker?

957

---

Do you know how to implement service broker?

938

---

Explain what is the main purpose of having conversation group?

953

---

Explain sql server service broker?

986

---

Tell me what do we need queues in sql service broker?

1008

---

How to encrypt data between dialogs?

1123

---

Explain isolation levels that sql server supports?

1050

---

Explain what is lock escalation and what is its purpose?

945

---

Explain different types of lock modes in sql server 2000?

941

---

What are the different types of lock modes in sql server 2000?

953

---

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

961

---

What is optimistic concurrency?

1046

---

Explain what are the events recorded in a transaction log?

1015

---

What is pessimistic concurrency?

984

---