In SQL Server 2008, lock escalation to Table object is default. You can make partition-level lock escalation as default as follows: ALTER TABLE [Table_Name] SET (LOCK_ESCALATION = AUTO); For more detailed explanation, see this: http://www.sqlservergeeks.com/articles/sql-server-bi/73/sql-server-2008-%E2%80%93-partition-level-locking Regards Quick Tip from SQLServerGeeks.com
Read More