OPTION (Max Recursion)

Question

OPTION (Max Recursion)

Viewing 10 posts - 16 through 24 (of 24 total)

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

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 1

Jeff Moden (9/7/2009)
I'd love to see a performance test between HID's and the Nested Set Model for both up and downline queries as well as the addition and deletion of mid hierarchy nodes.
Guess I'm going to have to load 2k8 Dev and start practicing this stuff.

I look forward to learning from your efforts Jeff!!

BTW, are you going to PASS this year? Would love to meet you.

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

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

TheSQLGuru (9/7/2009)
BTW, are you going to PASS this year? Would love to meet you.

This is NOT an on-line dating service :laugh:

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 3

Paul White (9/7/2009)
This is NOT an on-line dating service :laugh:

BWAA-HAA!!!... says the man wearing a blanket over his head. 😀

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

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 4

TheSQLGuru (9/7/2009)
I look forward to learning from your efforts Jeff!!

Heh... me too, Kevin. 😛

Yep... I'm going to PASS this year... learned my lesson by missing it last year.

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

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 5

Paul White (9/7/2009)
TheSQLGuru (9/7/2009)
BTW, are you going to PASS this year? Would love to meet you.
This is NOT an on-line dating service :laugh:

:w00t:

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

Fraggle-805517 SSCrazy Eights Points: 8907 More actions · Answer 6

I am very interested as well to see the difference Jeff.

Fraggle

RBarryYoung SSC Guru Points: 143329 More actions · Answer 7

Paul White (9/7/2009)
TheSQLGuru (9/7/2009)
BTW, are you going to PASS this year? Would love to meet you.
This is NOT an on-line dating service :laugh:

??? . It isn't?!? Dag'nabbit, you mean I've wasted the last 18 months here? 🙁 Well, that *does* explain a lot though ... 😛

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 8

It'll take quite a while, Fraggle. I won't even be near a computer with SQL Server on it for another week.

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

Fraggle-805517 SSCrazy Eights Points: 8907 More actions · Answer 9

Fraggle-805517

SSCrazy Eights

Points: 8907

September 8, 2009 at 10:46 pm

#1050898

No worries Jeff.

Fraggle

sgmunson SSC Guru Points: 110640 More actions · Answer 10

RBarryYoung,

I suspect you've been away from MLM / network marketing for a while. It's now quite common for the latest and greatest thing since sliced bread to be marketed with a "straight-line" plan, where every level has just 1 possible leaf node. What you're missing is the fact that when marketed right online, it's not the least bit uncommon for these things to be "pre-loaded" with thousands of "pre-signed-up people", who are all put in a single straight-line in the commission structure, and the thing launches with a couple thousand people who "get in at the top", so to speak. With the proper online promotion, these things can easily bring in 300 to 500 people a day, or more (BIG CAVEAT - this occurs for maybe 2 to 6 months, at best, and probably not that long in most cases), as opposed to just one, because there's no longer any branching involved based on who does the recruiting. Most often, the straight-line is nothing more than a feeder program to the more traditional MLM, and is usually designed to front-load some commission to the joiner who benefits from the straight-line while awaiting his/her reaching the more lucrative commissions potential in the program being fed.

Thus, the idea of a 32,000 level heirarchy isn't as impossible as your math suggests. Of course, a straight-line structure is nothing more than an ordered list, but all too many MLM people wouldn't know the difference. Even with the "2-BY" programs, where every level has at most 2 leaf nodes, much of that ends up in a straight line anyway, because it's not unusual for a promise to go out that guarantees the company's marketing will recruit for you until your left side is done, and it's always going to be easier for them to do that if they go in a straight line to do so. Of course, that one-sided-ness has a couple of problems: 1) it forces everyone to recruit at least one person on their own, but doesn't provide the how to, or the tools to be successful at it, and 2) once the structure is so lopsided from early company marketing efforts, the only folks making any money are the company and the top of the line.

On a slightly different tack, given that so many of these MLM programs are so highly impractical for more than the top few hundred folks to really make any money, with most of the rest of the folks that join losing money, I'm not all that motivated to help out with this kind of thing, because 32,000 levels tells me 99% of what I need to know about how that particular program works and how unlikely it is for most who join to make even one red cent. Call me skeptical... but been there, been burned... and more than once... (hopefully I've finally learned that lesson...)

Steve

(aka smunson)

:-):-):-)

Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)