Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Table Valued functions Vs Scalar Valued Functions RE: Table Valued functions Vs Scalar Valued Functions

  • June 27, 2008 at 8:09 am

    #835365

    TheSQLGuru (6/27/2008)

    At each of my last 3 SQL 2005 performance tuning/analysis client gigs I have addressed tremendous performance issues by removing the use of TVFs (and also table variables). It is amazing how inefficient these features can make queries and how frequently they can lead the optimizer to implement an inefficient query! Nested loops on M+ row tables is soooo ugly. :w00t:

    I absolutely agree, Kevin... not so hidden RBAR on steriods!

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