To fix blocking & deadlocks, you have 3 tools:
Have enough indexes to make your queries fast, but not so many that they slow down delete/update/insert operations. (I cover that in the Mastering Index Tuning class.) Use the right isolation level for your app’s needs. (I cover that in the Mastering Server Tuning class.) Tuning your T-SQL to work through tables in a consistent order and touch them as few times as possible.
I’ll cover #3 in a one-hour webcast with Quest Software on Thursday at noon Eastern. Register here.
This week’s sponsor: Top notch training on SQL Server, Power