Define master database?
Explain transaction server auto commit?
What are the essential components of sql server service broker?
Why do we use non clustered index?
How to use the inserted and deleted pseudo tables?
Define full outer join?
Explain concepts of analysis services?
Explain where clause?
What are the advantages of sql stored procedure?
Explain syntax for disabling triggers?
Define left outer join?
How dts is used to extract, transform and consolidate data?
How to implement service broker?
What is fill factor and pad index?
What are constraints in microsoft sql server?