mostlylucid

scott galloway's personal blog...

posts - 897, comments - 700, trackbacks - 11

My Links

News

Post Categories

Misc. Coding

<< Really odd IIS 6.0 'bug' when updating Stylesheets... | Home | Random brain fart... >>

Transact-SQL Tips

Transact-SQL Tips

Interesting tip on SQL Server hierarchies (using the standard parent-child hierarchies as opposed to Nested Sets)

Scott Galloway

Print | posted on Wednesday, March 23, 2005 10:38 AM |

Feedback

# re: Transact-SQL Tips

But it's still a loop! Nested sets are pure sex for hierarchical data, once you figure out how to do it. :)

3/23/2005 2:36 PM | Darrell

# re: Transact-SQL Tips

Absolutely, Nested Sets are by far my preferred method...but it does take a bit of getting around...stuff like copying bits around the hierarchy and such can get pretty tricky. Plus there's the problem with sites with lots of updates (having to use widely spaced nodes). Get around those though and there little to beat Nested Sets though; simple demonstration is showing the performance of finding all the child nodes of the current one... I posted on this stuff previously... http://www.mostlylucid.co.uk/archive/2004/07/06/1188.aspx

3/23/2005 3:42 PM | Scott Galloway