Home Forums SQL Server 2012 SQL 2012 - General Mysterious deadlocks on a heap table RE: Mysterious deadlocks on a heap table
Eirikur Eiriksson
SSC Guru
Points: 182882
More actions
July 5, 2014 at 1:04 pm
#1727171
I've come across this problem few times in the recent past and found that Implicit conversion from CHAR/VARCHAR to NCHAR/NVARCHAR and vice versa, will cause Index Scans which can lead to deadlocking.
😎