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

2014-09-19 (first published: )

29,597 reads

Blogs

Daily Coping 17 Sep 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Ethics in Modern Data at Music City Tech 2021

By

  On Sept 16, Christine and I presented our joint presentation on Ethics in Modern Data at...

Slides and Video from Building a Regret-free Foundation for your Data Factory Now Available

By

Last week, Kerry and I delivered a webinar with tips on how to set...

Read the latest Blogs

Forums

SQL Agent job

By Chitown

Can I run extended event session against 1 SQL agent job? I have a...

Need some help with tsql code

By Chitown

I have 4 tables (DevDB, TestDB, StageDB, ProdDB). All those tables have 2 columns...

Save Blob Storage Key in Package

By alex.sqldba

Hi Guys, Is there a way to save the Blob Storage Key into a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers