Rich Weissler (6/20/2013)
(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...
+1
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”