Answer Posted / balu

xp means Extended Procedure . These procedrue are made from
dlls written in c++.

What is difference in performance between insert top (n) into table and using top with insert?

973

---

Can you explain important index characteristics?

941

---

What is difference between clustered index and non clustered index?

1030

---

What is a join in sql? What are the types of joins?

1010

---

how you can deploy an ssrs report?

172

---

What is the difference between upgrade and migration in sql server?

1026

---

What is the template in sql?

919

---

Your table has a large character field there are queries that use this field in their search clause what should you do?

854

---

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

953

---

Explain transaction server implicit?

925

---

What is not null constraint?

1055

---

What is extent? Types of extents?

1089

---

How to use go command in "sqlcmd"?

1130

---

What do you mean by the term 'normalization'?

1128

---

what is unique and xaml nonclustered index

997

---