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

1032

---

What is a view in sql?

1026

---

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

1270

---

What are the different types of subquery?

1210

---

Can sql servers link to other servers like oracle?

898

---

Why we use the openxml clause?

1059

---

Can one drop a column from a table?

1069

---

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

1141

---

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?

1006

---

What is a not null constraint?

1093

---

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

1164

---

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

1026

---

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

1034

---

What will be the maximum number of indexes per table?

1021

---

What xml support does the sql server extend?

1062

---