Explain the disadvantages of cursors?

1164

---

What is key set driven?

971

---

Explain the cursor lock types?

1070

---

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

969

---

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

987

---

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

1018

---

Explain the functionalities that views support?

1132

---

What are xml indexes?

964

---

What is the openxml statement in sql server?

1088

---

What is for xml in sql server?

1091

---

How to call stored procedure using http soap?

1088

---

Can you explain what is indexed view? How to create it?

920

---

Explain what are partitioned views and distributed partitioned views?

954

---

Do you know what are the restrictions that views have to follow?

1093

---

What are secondary xml indexes?

1045

---