Explain throw statement in sql server 2008?

1058

---

What is nonclustered index on computed columns?

1004

---

Explain some stored procedure creating best practices or guidelines?

1008

---

Explain try...catch with sql server?

1073

---

What are sp_configure commands and set commands?

1085

---

What is the ‘fillfactor’?

1019

---

What is read uncmmited?

1124

---

What is an sql server agent?

1121

---

What is the difference between for trigger and after trigger?

1172

---

What are the steps you can take to avoid “deadlocks”?

1026

---

Explain user defined views?

1017

---

What is catalog views?

1126

---

What is table-valued sub query?

1028

---

What is the difference between a function and a stored procedure?

1128

---

What is the difference between update lock and exclusive lock?

1030

---