GilaMonster (1/22/2013)

---

bugg (1/22/2013)

---

GilaMonster (1/22/2013)

---

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

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?