Home Forums SQL Server 2005 Administering Deadlocks RE: Deadlocks

  • July 9, 2008 at 9:03 pm

    #840601

    terry.jago (7/9/2008)

    Yes it is possible to have no deadlocks, however, in this day and age most code is written badly, however, if you do get deadlocks there is no need to worry as the system will detect this and kill one of the processes.

    Terry

    ...which also causes either performance loss due to the inherent rollback or dataloss because something didn't happen right, or both. That's why I'm always busting chops about doing it right the first time or take 6 times longer to find it and fix it later. 😉

    Worry about deadlocks :w00t: Shoot for zero deadlocks and high performance scalable code or find a new profession (NOT directed at you, Terry!).

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)