bugg (1/22/2013) GilaMonster (1/22/2013)
Any insight into dealing with deadlocks would be greatly appreciated.
Optimise the queries. If that doesn't fix the problem use one of the row versioning-based isolation levels
Thanks Gila, I'm going to try using Rowlock with the update commands and see if that clears the locks.
Optimise your queries, don't mess with locking hints unless you really understand what you're doing and why and have optimised as much as possible.
You do realise that a row lock hint means more chance of lock escalation (to table), not less?
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass