Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Help avoiding temp table with string of IDs passed into stored procedure RE: Help avoiding temp table with string of IDs passed into stored procedure

  • October 2, 2014 at 8:53 am

    #1749702

    Heh... have you done an actual test to see which is better? You have to remember that even supposed "actual" excution plans are estimates in many ways.

    Execution plans help you figure out what needs to be done for performance tuning and shouldn't be used as some form of performance "measurement".

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