Hi all,
At this URL (https://msdn.microsoft.com/en-us/library/ms190273.aspx) explaining the various available ALTER TABLE arguments, there is one that particularly concern us.
This is this one:
<table_option> ::=
{
SET ( LOCK_ESCALATION = { AUTO | TABLE | DISABLE } )
}
SET( LOCK_ESCALATION = { AUTO | TABLE | DISABLE })
Applies to: SQL Server 2008 through SQL Server 2016, SQL Database V12. |
Specifies the allowed methods of lock escalation for a table.
...
DISABLE
Prevents lock escalation in most cases. Table-level locks are not completely disallowed. For example, when you are scanning a table that has no clustered index under the serializable isolation level, Database Engine must take a table lock to protect data integrity.
-------------------------------
More precisely we wanted to know exactly in which cases a table that have been set to LOCK_ESACALATION = DISABLE can still do lock escalation apart from the example given that URL.
Can someone give us a complete list?
Best regards.
Carl