Explain what is lock escalation and what is its purpose?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What is the most common trace flags used with sql server?

0 Answers  


How to assign null values to variables or columns?

0 Answers  


What are triggers in ms sql server?

0 Answers  


What do you understand by mirroring?

0 Answers  


What are scheduled tasks in sql server?

0 Answers  






Explain transaction server explicit transaction?

0 Answers  


What is reference section?

0 Answers  


How To delete duplicate record from a particular table?

12 Answers   eXensys, Foxfire,


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

1 Answers  


what is a correlated sub-query? : Sql server database administration

0 Answers  


How do you drop an index?

0 Answers  


Does the order of columns in update statements matter?

0 Answers  


Categories