Explain transaction server distributed transaction?
how would you store your query in an SSRS report or a Database server?
Why do we use trigger?
How many types of database relationship in sql server?
What is checkpoint in sql server?
what data regions are and what are the different data regions?
when would you go for denormalization? : Sql server database administration
What is molap and its advantage? : sql server analysis services, ssas
What is the contrast between sql and mysql?
Where is trigger in sql server?
What is constraints and its types?
Explain the steps needed to create a scheduled job?
What is the difference between a view and a stored procedure?
What is a cursor, index in sql?
How to enable/disable indexes?