What are the steps you will take to improve the performance of a poor performing query?
What is an index. What are the types?
What does the automatic recovery do?
What are views in ms sql server?
How to list all triggers in the database with sys.triggers in ms sql server?
Explain about sql server login?
How to Rebuild Master database in sql server 2005.
What is subquery? Explain the properties of a subquery?
How do I compare two values when one value(data type) is char and the other is an integer?
What is page-level compression?
How do you open a cluster administrator?
Issues related in upgrading SQL Server 2000 to 2005 / 2008
What are orphan records?