Do you know nested transaction?
What is difference between materialized view and view?
How to view the error log for any specific instance? : sql server database administration
What is use of except clause? How does it differ from not in clause?
Why is normalisation important?
How many triggers are possible per table?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
What is exporting utility?
Explain sql server authentication modes?
What is the system function to get the current user's user id?
Do you know the different ddl commands in sql?
What are cursors stored procedures and triggers?
How to apply cascading referential integrity in place of triggers?