Thursday, October 13, 2011

Indexes causes deadlocks in SQL Server

Another common scenario for deadlock
If make a lot of indexes with same set of columns but sequence is different, can cause deadlocks between select/update query.
Carefully design indexes for a table, don’t let tuning advisor do it for you.


No comments:

Post a Comment