Set based iteration

Question

Set based iteration

Viewing 2 posts - 46 through 46 (of 46 total)

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

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

SQL Kiwi (5/26/2012)
The difficulty you are having here is exactly why I said the meaning of 'set-based' is a bit woolly, in response to Sean saying that recursive CTEs are not set-based.
...
{snip}
...
I deliberately did not give a definition of 'set-based';
...
{snip}
...
Extending the meaning of 'set-based' into the physical domain therefore seems flawed.

Now there's a lesson learned. It can also be applied to what I've been calling "Hidden RBAR". From what we've seen on this thread, "Hidden RBAR" can be considered to be "set based" just as even "Counting rCTEs" can be considered "set based". I've included the term "set based" in quotes because it [font="Arial Black"]IS [/font]a woolly term that appears to have many meanings to many people and I don't want to be in the controversial business of trying to define the term any longer. It's aggravatingly woolly (to coin a phrase) and I'll likely strike the term from my vocabulary except to say that it is woolly.

Shifting gears, you've not answered the question that's much more important to me than any of this SQL stuff. Are we good now?

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

Paul White SSC Guru Points: 150467 More actions · Answer 2

Jeff Moden (5/26/2012)
Are we good now?

Sure. 😎

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi