Partition Level Locking SQL CAT Post

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 versions a trace flag was used to alter lock escalation.

A great feature added to an already great feature.  Enjoy!


Posted by: whitneyw
Posted on: 3/11/2010 at 1:22 PM
Tags:
Categories: SQL Server | Transact SQL
Actions: E-mail | Kick it! | DZone it! | del.icio.us
Post Information: Permalink | Comments (0) | Post RSSRSS comment feed
Comments are closed