What are the advantages of stored procedure in sql server?
Explain about nested stored procedure?
What is dbcc? Give few examples.
Is BCNF better than 2NF & 3NF? Why?
What is the difference between for xml raw and for xml auto?
What are the dmvs?
What is resource governor in sql server?
Give an example of why you would want to denormalize a database
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
What is self contained scalar sub query?
What command would you use to create an index?
What is a self join in sql server?
Tell me what is difference between view and materialized view?
What is collation?
How to find Duplicate Records In table?