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

1009

---

How to encrypt data between dialogs?

1127

---

Explain isolation levels that sql server supports?

1052

---

Explain what is lock escalation and what is its purpose?

952

---

Explain different types of lock modes in sql server 2000?

948

---

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

961

---

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

961

---

What is optimistic concurrency?

1058

---

Explain what are the events recorded in a transaction log?

1015

---

What is pessimistic concurrency?

993

---

Do you know the isolation level that sql server support?

977

---

Explain optimistic and pessimistic concurrency?

1005

---

Explain the various types of concurrency problem?

1209

---

Do you know what are the differences between lost updates and uncommitted dependencies?

1103

---

What is sql server locking?

1003

---