Do you know concepts and capabilities of sql server?

1059

---

Explain how to use linked server?

991

---

What do you mean by an execution plan? How would you view it?

914

---

Do you know what are acid properties of transaction?

952

---

Explain what is lock escalation?

1064

---

Explain what are magic tables in sql server?

994

---

Tell me what are cursors and when they are useful?

954

---

Do you know what is a linked server in sql server?

1024

---

Do you know what is difference between stored procedure and user defined function?

1089

---

Tell me when is the update_statistics command used?

1110

---

Explain the xml support sql server extends?

1040

---

Explain the rules for designing files and file groups in sql server?

986

---

Do you know what is rank function?

1073

---

Tell me what is normalization? Explain different forms of normalization?

1030

---

Do you know what are acid properties?

1078

---