SQL Database Concepts Question: Download Questions PDF
Do you know what is Lock Escalation?
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 Question | Next Question |
| List down some advantages of SQL Stored procedure? | Explain what is RAID and what are different types of RAID levels? |