Post reply

Table variables vs. temp tables, and should I use subqueries to minimize # of updates in these?

  • August 17, 2009 at 9:00 pm

    #1040613

    jeff (8/17/2009)

    Jeff Moden - Oops, sorry, I thought you were being frivolous before; was kind of hard to tell what you meant. Thanks! I will check that out.

    Heh... no... I was just in a wicked hurry when I saw the post. Didn't have time to say much. The "quirky update" will allow you to do "cursor like" things in a single update. The big difference is in number of resources and absolute blazing speed.

    I'd have pointed you to my article on the subject except it's in the que to be republished.

    --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)
    Intro to Tally Tables and Functions

Viewing post 16 (of 15 total)

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