What is an execution plan? When would you use it?
Tell me what do we need queues in sql service broker?
What does truncate do?
Explain the phases a transaction has to undergo?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
How to work on DTS?what is the main requirement?
What is attribute? : sql server analysis services, ssas
What are logical database components? : SQL Server Architecture
What are the differences between char and varchar in ms sql server?
What are basics of policy management?
How do you rebuild an identity column?
How to change server name in sql server?
What is the native system stored procedure to execute a command against all databases?