What is default constraint?

1054

---

Explain table valued parameters in sql server? Why tvp used?

1070

---

How to return the date part only from a sql server datetime datatype?

1169

---

What is difference between delete and truncate commands?

1176

---

What is implicit mode in sql server?

1162

---

What is Extended user-defined?

1031

---

what is hash nonclustered index

1025

---

Find columns used in stored procedure?

1041

---

How to rebuild the master database?

1138

---

Why the trigger fires multiple times in single login?

1284

---

How to optimize stored procedure optimization?

969

---

What is use of except clause?

1147

---

What is an execution plan? When would you use it?

1028

---

What are “lock” hints?

1108

---

Explain ranking functions?

1099

---