Post reply

Doubt on Temporary tables

  • July 7, 2005 at 7:51 pm

    #572140

    You CAN get an estimated execution plan when you use temp tables by first executing just the code that makes the temp tables and then doing the execution plan.  If you have RETURNs that return something, you'll also need to replace "RETURN " with "RETURN --" to comment out the integers that follow.  Don't forget to undo that if you forgot to do a save before you started...

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

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply