Tuesday, October 18, 2011
Monday, October 17, 2011
Friday, October 14, 2011
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.
Solution:
Carefully
design indexes for a table, don’t let tuning advisor do it for you.
Reference:
Subscribe to:
Posts (Atom)