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

Question

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

Viewing post 16 (of 15 total)

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

Jeff Moden SSC Guru Points: 1004561 More actions · Answer 1

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)

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

Cookies on SQLServerCentral