bugg (1/22/2013)
Any insight into dealing with deadlocks would be greatly appreciated.
In general:
Optimise the queries. If that doesn't fix the problem use one of the row versioning-based isolation levels
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability