A little late with this one but the SQL CAT team has a great blog post about partition lock escalation in SQL Server 2008. The post describes the introduction of table level lock escalation control made available via TSQL syntax. In prior
Read More...