How do you implement session management in SQL Server mode?
How to insert and update data into a table with "insert" and "update" statements?
What is a data source or ds? : sql server analysis services, ssas
Which are ddl commands?
What is a data collection table?
What is buffer cash and log cache in sql server?
Tell me what are the essential components of sql server service broker?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
Do you know nested transaction?
Explain activity monitors
Explain why variables called the most powerful component of ssis?
Explain Capacity planning to create a database? and how to monitor it?
What is the difference between clustered and a non-clustered index?
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
Is foreign key unique?