Sql Interview Question #9 : What is new in lock escalation in SQL Server 2008? This entry was posted in Sql Server 2008 Sql Server Interview Questions Sql Server tutorials and tagged ddl dml lock escalation logon server sql trigger on 10/24/2014 by Blog Admin. Sql Server Interview Question #9 What is new in lock escalation in SQL Server 2008?