• (from the question today)

    > [...]triggers Lock Escalation (i.e. Row lock to Page level lock)

    This would seem to refer to an event that sets off the mental alarms...

    (from the reference)

    > The Database Engine does not escalate row or key-range locks to page locks, but escalates them directly to table locks.

    My memory was that Lock Escalation from row or page level always jumps to table. I assume I'm simply misinterpreting the question, but figured I'd ask/point just 'cause I haven't had my coffee yet...