<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss Content Posted by Jeff Moden
»
Hierarchies on Steroids #2: A Replacement for...
29 posts, Page 1 of 3
1
2
3
»
»»
Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations
Rate Topic
Display Mode
Topic Options
Author
Message
Jeff Moden
Jeff Moden
Posted Thursday, November 15, 2012 12:03 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 7:18 AM
Points: 33,112,
Visits: 27,038
Comments posted to this topic are about the item
Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations
--Jeff Moden
"
RBAR
is pronounced "ree-bar" and is a "Modenism" for "
R
ow-
B
y-
A
gonizing-
R
ow".
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."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1384987
Theo Ekelmans
Theo Ekelmans
Posted Thursday, November 15, 2012 2:16 AM
Grasshopper
Group: General Forum Members
Last Login: Today @ 6:12 AM
Points: 17,
Visits: 303
Another excellent article, John ! This is really usefull.
Keep e'm coming
Theo
(NL)
Post #1385014
Jeff Moden
Jeff Moden
Posted Thursday, November 15, 2012 7:21 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 7:18 AM
Points: 33,112,
Visits: 27,038
Theo Ekelmans (11/15/2012)
Another excellent article, John ! This is really usefull.
Keep e'm coming
Theo
(NL)
Thanks, Theo. (my name isn't "John", though
).
--Jeff Moden
"
RBAR
is pronounced "ree-bar" and is a "Modenism" for "
R
ow-
B
y-
A
gonizing-
R
ow".
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."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1385149
Michael Meierruth
Michael Meierruth
Posted Thursday, November 15, 2012 11:21 AM
SSC-Addicted
Group: General Forum Members
Last Login: 2 days ago @ 12:38 AM
Points: 483,
Visits: 1,625
They both start with J. He was close.
Post #1385284
SQLRNNR
SQLRNNR
Posted Thursday, November 15, 2012 2:06 PM
SSCoach
Group: General Forum Members
Last Login: Today @ 3:33 PM
Points: 18,858,
Visits: 12,443
Another fine piece Jeff.
Jason
AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008
SQL RNNR
Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1385362
JJ B
JJ B
Posted Thursday, November 15, 2012 2:44 PM
SSC Veteran
Group: General Forum Members
Last Login: Today @ 12:30 PM
Points: 259,
Visits: 2,424
Wow. Both articles are awesome. Not only is your code well documented (as usual), but the charts were also extremely useful in helping to explain the text. Well done and thanks for taking the time to really explain the methods.
Post #1385371
adrian.facio
adrian.facio
Posted Thursday, November 15, 2012 3:36 PM
Old Hand
Group: General Forum Members
Last Login: Monday, January 21, 2013 8:22 AM
Points: 313,
Visits: 312
Learned a lot.
Post #1385383
dwain.c
dwain.c
Posted Thursday, November 15, 2012 7:28 PM
SSCrazy
Group: General Forum Members
Last Login: Today @ 1:40 PM
Points: 2,370,
Visits: 3,251
Jeff - Working through it now but its pretty deep and I expect it will take me awhile.
Great explanations though!
I'm going to try to see if I can adapt the approach to another problem I encountered recently that is "not quite" a hiearchy.
Let me know if you decide to change your name to John. I have several article attributions to you I'll need to change.
No loops! No CURSORs! No RBAR! Hoo-uh!
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?
Since random numbers are too important to be left to chance, let's generate some!
Are you too recursively challenged?
Splitting strings based on patterns can be fast!
Post #1385418
Jeff Moden
Jeff Moden
Posted Thursday, November 15, 2012 11:54 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 7:18 AM
Points: 33,112,
Visits: 27,038
Michael Meierruth (11/15/2012)
They both start with J. He was close.
4 Letters, too!
--Jeff Moden
"
RBAR
is pronounced "ree-bar" and is a "Modenism" for "
R
ow-
B
y-
A
gonizing-
R
ow".
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."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1385486
Jeff Moden
Jeff Moden
Posted Thursday, November 15, 2012 11:57 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 7:18 AM
Points: 33,112,
Visits: 27,038
dwain.c (11/15/2012)
Jeff - Working through it now but its pretty deep and I expect it will take me awhile.
Great explanations though!
I'm going to try to see if I can adapt the approach to another problem I encountered recently that is "not quite" a hiearchy.
Let me know if you decide to change your name to John. I have several article attributions to you I'll need to change.
Thanks, Dwain. I'd be interested in your "not quite a hierarchy" problem. Sounds interesting.
Heh... nah. Not going to change my name. Too much paper work for us all.
--Jeff Moden
"
RBAR
is pronounced "ree-bar" and is a "Modenism" for "
R
ow-
B
y-
A
gonizing-
R
ow".
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."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1385488
« Prev Topic
|
Next Topic »
29 posts, Page 1 of 3
1
2
3
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
