http://www.sqlservercentral.com/Articles tagged Nested Sets posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)In this sequel to his first "Hierarchies on Steroids" article, SQL Server MVP Jeff Moden shows us how to build a pre-aggregated table that will answer most of the questions that you could ask of a typical hierarchy. Any bets on whether Santa is packin’ a Tally Table in his bag or not?

]]>http://www.sqlservercentral.com/articles/T-SQL/94570/Thu, 15 Nov 2012 07:00:00 UThttp://www.sqlservercentral.com/articles/T-SQL/94570/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".

]]>http://www.sqlservercentral.com/articles/Hierarchy/94040/Tue, 13 Nov 2012 07:00:00 UThttp://www.sqlservercentral.com/articles/Hierarchy/94040/