Is there a way to find the current setting for LOCK_ESCALATION on particular table? Can it be found through system views?
In SQL Server, locks are normally escalated from row or page -> table. Starting with SQL Server 2008, a new level of lock escalation was added - partition level. However, this isn't automatically ...