List all the types of user-defined functions?

1192

---

Why use “nolock” in sql server?

1140

---

Explain primary key in sql server?

1080

---

What is the filtered index?

1113

---

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

962

---

How will you go about resolving deadlocks?

1036

---

What is the difference between osql and query analyzer?

1048

---

What is a join in sql?

1161

---

Why use update_statistics command in sql server?

1119

---

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

1047

---

What are locks in sql?

1019

---

In what sequence sql statement is processed?

1059

---

Explain how many types of relationship?

1086

---

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

1027

---

List the different types of collation sensitivities in sql server?

1086

---