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".
Read more...
By
Jeff Moden
2014/09/19 (first published: 2012/11/13)
|
Source:
SQLServerCentral.com
|
Category:
hierarchy