SQL Database Concepts Question:

Download Job Interview Questions and Answers PDF

Do you know what is Lock Escalation?

Basic SQL Server Interview Question
Basic SQL Server Interview Question

Answer:

Lock escalation is the process of reducing the overhead of the system by converting many fine grain locks into fewer coarse grain locks. Lock escalation threshold is determined dynamically by SQL server. It doesn’t require any configuration hassles as SQL Server choose to keep lock on both row and column for the page query.

Download Basic SQL Server Interview Questions And Answers PDF

Previous QuestionNext Question
List down some advantages of SQL Stored procedure?Explain what is RAID and what are different types of RAID levels?