What is lock escalation?
I was asked this question at an interview and had no answer. Can anyone here explain? ...
lock-escalation
Regarding DB Locks and Lock Escalation SQL Server 2008
Dear Gurus I have seen many articles and Questions/Answers Regarding Lock Escalation but following things are still vague. Please answer to the specific required information. If Lock Escalation is disabled will there be Intended Locks on higher resources like on Page or Table??? If a Lock(IX) is placed on Page can another connection a...