Alexander Kuznetsov : Deadlockhttp://sqlblog.com/blogs/alexander_kuznetsov/archive/tags/Deadlock/default.aspxTags: DeadlockenCommunityServer 2.1 SP2 (Build: 61129.1)Some heap tables may be more prone to deadlocks than identical tables with clustered indexeshttp://sqlblog.com/blogs/alexander_kuznetsov/archive/2009/03/11/some-heap-tables-may-be-more-prone-to-deadlocks-than-identical-tables-with-clustered-indexes.aspxThu, 12 Mar 2009 03:05:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:12576Alexander Kuznetsov31http://sqlblog.com/blogs/alexander_kuznetsov/comments/12576.aspxhttp://sqlblog.com/blogs/alexander_kuznetsov/commentrss.aspx?PostID=12576Apparently for high isolation levels some heap tables may be more prone to deadlocks than identical tables with clustered indexes. I have a simple repro script which successfully completes if a table has a clustered index but embraces in a deadlock if...(<a href="http://sqlblog.com/blogs/alexander_kuznetsov/archive/2009/03/11/some-heap-tables-may-be-more-prone-to-deadlocks-than-identical-tables-with-clustered-indexes.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=12576" width="1" height="1">DeadlockSQL ServerTransact SQL