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..
| Previous Question | Next 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? |