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

990

---

What is a view in sql?

983

---

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

1239

---

What are the different types of subquery?

1175

---

Can sql servers link to other servers like oracle?

854

---

Why we use the openxml clause?

1025

---

Can one drop a column from a table?

1031

---

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

1093

---

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?

956

---

What is a not null constraint?

1046

---

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

1112

---

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

990

---

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

986

---

What will be the maximum number of indexes per table?

975

---

What xml support does the sql server extend?

1024

---