Explain what is lock escalation and what is its purpose?
What is the most common trace flags used with sql server?
How to assign null values to variables or columns?
What are triggers in ms sql server?
What do you understand by mirroring?
What are scheduled tasks in sql server?
Explain transaction server explicit transaction?
What is reference section?
How To delete duplicate record from a particular table?
when u import an excel file into sql if suppose one column has got a date field with system time attached to it what data type u will use in sql to import it in a table? Note: a condition is the excel file has no primary key defined to a column...also u r importing bulk data into sql
what is a correlated sub-query? : Sql server database administration
How do you drop an index?
Does the order of columns in update statements matter?