Home Forums SQLServerCentral.com Articles Requested Bad Scalar Functions (or other UDF) RE: Bad Scalar Functions (or other UDF)

  • December 4, 2017 at 10:15 am

    #1970563

    Steve Jones - SSC Editor - Friday, May 20, 2016 10:18 AM

    Thanks, Jeff. Hoping for a few pieces. We have the one you wrote on moving a scalar UDF to a CROSS APPLY, but I'd like to get more references for specific functions that might do strange things.

    My sincere apologies.  I'm way overdue on this and other articles (it's been several years since I put one out there).  Hopefully, things will lighten up on my end and I'll be able to crank the one I was thinking of for this out soon.

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