|
|
|
|
Browse by Tags
All Tags » Transact SQL » Deadlock (RSS)
-
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 ...
|
|
|
|
|