List all the types of user-defined functions?

1118

---

Why use “nolock” in sql server?

1069

---

Explain primary key in sql server?

1030

---

What is the filtered index?

1072

---

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

916

---

How will you go about resolving deadlocks?

980

---

What is the difference between osql and query analyzer?

1012

---

What is a join in sql?

1105

---

Why use update_statistics command in sql server?

1066

---

List out the difference between union and union all in sql server?

1001

---

What are locks in sql?

991

---

In what sequence sql statement is processed?

1024

---

Explain how many types of relationship?

1043

---

What is de-normalization in sql database administration? Give examples?

992

---

List the different types of collation sensitivities in sql server?

1054

---