Explain having clause and where clause?
What is the index requirement in SQL Azure?
Explain a differential backup?
What does it mean to invest in the index?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What is sql service broker?
What are various limitations of the views?
What are the different authentication modes in sql server? How can it be changed?
What is the default schema of your login session in ms sql server?
what are isolation levels? : Sql server database administration
Explain transaction server consistency?
What is SQL Azure?
What is the difference between coalesce() & isnull()?
what are the new features in SSRS?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration