• It certainly doesn't apply to everyone but I've found a lot of people that have such proverbial "Single Pane of Glass" tools either don't know how to use them to realize a problem is occurring or they don't know how to isolate the problems never mind actually fixing them.  A great example of this is when people find certain wait stats that have gone off the scale.  The first thing they do is blame the hardware instead of looking for poorly written code that has stacked up in the gullet of SQL Server because no machine could do otherwise.  Such mistakes also lead to the erosion of the notion of DevOps because it turns into a blame game, correct or not.

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