3 ms·SQL Server will escalate locks. Because keeping a million rows locked is expensive.by quickthrower2 3y agoSQL Server will escalate locks. Because keeping a million rows locked is expensive.