• No, no... the rant is understood and appreciated. When I first reported to my company, they had and average of 640 deadlocks a day with spikes to 4,000, no documentation in the code, and every time the DBA went to promote some code to production, it would always fail on the first run.

    So, working with the DBA's, we ganged up on everyone... we wrote/published standards and told management how close they were to having a server meltdown... and that was no lie.

    It was a long hard battle to lock things down and get people educated (including the appdev and other managers) about the right way to write code... but it was worth it!

    --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)