What is a rollup clause?

1019

---

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

999

---

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

1064

---

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

1086

---

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

1126

---

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

1283

---

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

1123

---

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?

1092

---

What is the bookmark lookup and rid lookup?

1035

---

What is local temp table?

1024

---

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

1099

---

Explain insert into select statement?

1011

---

What are policy management terms?

1041

---