Explain throw statement in sql server 2008?

1054

---

What is nonclustered index on computed columns?

1000

---

Explain some stored procedure creating best practices or guidelines?

1005

---

Explain try...catch with sql server?

1072

---

What are sp_configure commands and set commands?

1081

---

What is the ‘fillfactor’?

1019

---

What is read uncmmited?

1120

---

What is an sql server agent?

1118

---

What is the difference between for trigger and after trigger?

1166

---

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

1026

---

Explain user defined views?

1012

---

What is catalog views?

1123

---

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?

1028

---