Is there a way to find the current setting for LOCK_ESCALATION on particular table? Can it be found through system views?
Looking at update MyTable set Status = 1 where Status = 0 of course- the where is calculated before the actual update. but does this filtering (where Status = 0) is also inside the lock ? I mean ...