• TheSQLGuru (6/10/2013)


    I had one client that actually had to ROLL BACK to the old, slow hardware because their system was essentially unusable!! No one ever thinks you need to test out new hardware before upgrading because it might be "too fast". :hehe:

    Agreed.

    As you have also but worth bringing up, I've also seen it where people spend some pretty big bucks on new hardware thinking that it will provide the performance panacea they've been looking for only to find that they get little or no performance gain simply because the code sucks THAT bad. SSD's are the likely exception to that rule.

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