SQL Database Concepts Question:

Download Job Interview Questions and Answers PDF

Explain what is lock escalation?

Basic SQL Server Interview Question
Basic SQL Server Interview Question

Answer:

Lock escalation from SQL Server 7.0 onwards, is dynamically managed by SQL Server. It is the process of converting a lot of low level locks into higher level locks..

Download Basic SQL Server Interview Questions And Answers PDF

Previous QuestionNext Question
Tell me what is use of EXCEPT clause? How it differs from NOT IN clause?Do you know what is difference between Index Seek vs. Index Scan?