List out the different types of locks available in sql server?

1037

---

What is a view in sql?

1027

---

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1275

---

What are the different types of subquery?

1222

---

Can sql servers link to other servers like oracle?

900

---

Why we use the openxml clause?

1059

---

Can one drop a column from a table?

1072

---

What are the main differences between #temp tables and @table variables and which one is preferred?

1146

---

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

1010

---

What is a not null constraint?

1096

---

What is the use of “join” in sql server?

1166

---

What are the steps you will take to improve the performance of a poor performing query?

1032

---

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

1042

---

What will be the maximum number of indexes per table?

1027

---

What xml support does the sql server extend?

1073

---