What is the ‘fillfactor’?

1015

---

What is read uncmmited?

1115

---

What is an sql server agent?

1113

---

What is the difference between for trigger and after trigger?

1161

---

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

1024

---

Explain user defined views?

1009

---

What is catalog views?

1121

---

What is table-valued sub query?

1026

---

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

1125

---

What is the difference between update lock and exclusive lock?

1028

---

Does the order of columns in update statements matter?

956

---

What is use of @@ spid in sql server?

1273

---

How to delete duplicate rows from table except one?

1044

---

Can we insert data if clustered index is disabled?

986

---

Explain system rowset functions?

1046

---