What is a rollup clause?

1023

---

How can I know what locks are running on which resource?

1002

---

When I delete any data from a table, does the sql server reduce the size of that table?

1065

---

What is user-defined functions? What are the types of user-defined functions that can be created?

1090

---

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

1130

---

How to find the list of fixed hard drive and free space on server?

1292

---

What is difference in performance between insert top (n) into table and using top with insert?

1126

---

What is change data capture (cdc) in sql server 2008?

1080

---

Where are sql server usernames and passwords stored in the sql server?

1176

---

Explain left outer join and right outer join?

1096

---

What is the bookmark lookup and rid lookup?

1040

---

What is local temp table?

1028

---

What is difference between getdate and sysdatetime in sql server 2008?

1103

---

Explain insert into select statement?

1015

---

What are policy management terms?

1045

---