Home Forums SQL Server 2008 SQL Server Newbies SQL Deadlocks RE: SQL Deadlocks

  • January 22, 2013 at 9:04 am

    #1579687

    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.