Adam Machanic : lock escalationhttp://www2.sqlblog.com/blogs/adam_machanic/archive/tags/lock+escalation/default.aspxTags: lock escalationenCommunityServer 2.1 SP2 (Build: 61129.1)SQL Server 2008: Lock Escalation, INSERTs, and a Potential Bughttp://www2.sqlblog.com/blogs/adam_machanic/archive/2009/10/30/sql-server-2008-lock-escalation-inserts-and-a-potential-bug.aspxFri, 30 Oct 2009 13:10:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:18376Adam Machanic9http://www2.sqlblog.com/blogs/adam_machanic/comments/18376.aspxhttp://www2.sqlblog.com/blogs/adam_machanic/commentrss.aspx?PostID=18376Lock escalation is a funny thing. I've found myself on numerous occasions waging war against its concurrency-sapping existence, and rarely have I found myself wishing that it would work more aggressively. But there is a time and place for everything,...(<a href="http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/10/30/sql-server-2008-lock-escalation-inserts-and-a-potential-bug.aspx">read more</a>)<img src="http://www2.sqlblog.com/aggbug.aspx?PostID=18376" width="1" height="1">lock escalationPerformancesql server 2008