» SQL Server
» Transact SQL
» Deadlock (RSS)
Sorry, but there are no more tags available to filter with.
Apparently 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 it runs against a heap. Here is the table:
CREATE TABLE dbo.NarrowTable(ID INT ...