Home Forums SQL Server 2008 SQL Server 2008 - General How to avoid Deadlock while deleting data RE: How to avoid Deadlock while deleting data
Seraj Alam-256815
SSC Eights!
Points: 804
More actions
March 29, 2013 at 11:41 am
#1602110
I guess there are two workaround for this.
1. exchange the clustered index. make clustered index on the column Internal_name.
or
2. use tablelock hint to avoid deadlock
by the way, what is fragmentation level of your table?