What is a rollup clause?
How can I know what locks are running on which resource?
When I delete any data from a table, does the sql server reduce the size of that table?
What is user-defined functions? What are the types of user-defined functions that can be created?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
How to find the list of fixed hard drive and free space on server?
What is difference in performance between insert top (n) into table and using top with insert?
What is change data capture (cdc) in sql server 2008?
Where are sql server usernames and passwords stored in the sql server?
Explain left outer join and right outer join?
What is the bookmark lookup and rid lookup?
What is local temp table?
What is difference between getdate and sysdatetime in sql server 2008?
Explain insert into select statement?
What are policy management terms?