Home Forums Article Discussions Article Discussions by Author Discuss content posted by Wayne Sheffield Performance Test of New Date Manipulation Functions (SQL Spackle) RE: Performance Test of New Date Manipulation Functions (SQL Spackle)

  • May 10, 2012 at 8:31 am

    #1485736

    As usual, awesome article, Wayne.

    It is a bit amazing to me that MS isn't, for some reason, able to do performance wise at the base code level what we're able to do at the "hack" level. I was really shocked when you test the previous row stuff against the Quirky Update. They should spend more time on stuff like making Pivot as useful as it is in Access. On second thought, it's already slow enough. Maybe they should leave it alone. 😀

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