Post reply

The Importance of Testing

  • February 17, 2020 at 12:00 am

    #3724778

    Comments posted to this topic are about the item The Importance of Testing

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • February 17, 2020 at 2:42 pm

    #3726438

    Speaking of automated testing, you should write a followup article about who tests the automated test software?  I can't speak for anyone else but we've had the occasional "whoops" occur even there.  In the panic that followed to fix the test software so they could meet a deadline, they fixed the original "whoops" and introduced another that was just as difficult to find and fix.

    BTW... +10,000,000 for pointing out that even the Actual Execution Plan is NOT a measure of performance.  People just don't seem to get that especially when they're comparing two execution plans.

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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply