Hierarchy

Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets

  • Article

SQL Server MVP Jeff Moden shows us a new very high performance method to convert an "Adjacency List" to “Nested Sets” on a million node hierarchy in less than a minute and 100,000 nodes in just seconds. Not surprisingly, the "steroids" come in a bottle labeled "Tally Table".

4.9 (60)

2014-09-19 (first published: )

22,577 reads

Blogs

Extended Events Misperceptions: Profiler is Easier

By

I know, I know, I’m on #teamexevents so I think that Extended Events can...

I’m Speaking at #SQLSatSpokane

By

I am super excited to announce that I have been selected to speak at...

Common commands and tasks to make dealing with Windows Core easier.

By

I don’t know how many of you are working with Windows Core these days...

Read the latest Blogs

Forums

Report Development

By 2Tall

Hi to all. I have not worked with SQL for a few years and...

Data Stage to SSIS Migration. I want to use the existing unix scripts in SSIS

By nsavita

Hi, I am working on a project migrating from data stage to SSIS. There...

Move Data from SQL Server to Azure Blob Storage with Incremental Changes – Part 2

By Ginger Keys Daniel

Comments posted to this topic are about the item Move Data from SQL Server...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers