Answer Posted / jai

A clustered index sorts and stores the data rows in the table based on the index key values. Therefore only one clustered index can be created on each table because the data rows themselves can only be sorted in one order.

Using the customer, and order table in northwind database, please write a query to produce xml?

1076

---

What specific conditions database should meet, before you can bulk copy data into it using bcp?

986

---

What is the purpose of update statistics and scope_identity() function?

1100

---

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

1026

---

What are extended events in sql server?

955

---

What is the maximum size per database for sql server express?

1053

---

Can we use trigger new in before insert?

922

---

What does dml stand for?

949

---

How to set a database state to offline in ms sql server?

1046

---

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

1033

---

Explain the disadvantages/limitation of the cursor?

963

---

What are the mathematical functions supported by sql server 2005?

1071

---

How can you find out how many rows returned in a cursor?

1030

---

What is ms sql server triggers?

1014

---

What is the user of Primary key?

990

---