Hierarchy

SQLServerCentral Article

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

You rated this post out of 5. Change rating

2014-09-19 (first published: )

42,249 reads

Blogs

Prepping for Certification, Part 1 of ?

By

I thought it would be good to put my thoughts down on how to...

How to Avoid Knowledge Stagnation

By

You want the short answer? Well, the only antidote to knowledge stagnation is probably...

Demystifying Fabric Workspaces: The Nerve Center of Your Data Universe

By

It always starts the same way. You open your laptop on a Monday morning,...

Read the latest Blogs

Forums

is there a way to "detect" schema like changes on a server?

By stan

Hi, we have a few people who like to experiment on our prod sql...

Guidelines and Requirements

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Guidelines and Requirements

Copying Production Schema

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Copying Production Schema

Visit the forum

Question of the Day

Copying Production Schema

If I use DBCC CLONEDATABASE, can I remove some of the information from the copy?

See possible answers