SQLServerCentral.com Content tagged T-SQL, Nested Setshttp://www.sqlservercentral.com/Content tagged T-SQL, Nested Sets posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Hierarchies on Steroids #2: A Replacement for Nested Sets CalculationsIn 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/Hierarchies on Steroids #1: Convert an Adjacency List to Nested SetsSQL 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".

sqldbabundle ‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now
]]>http://www.sqlservercentral.com/articles/Hierarchy/94040/Tue, 13 Nov 2012 07:00:00 UThttp://www.sqlservercentral.com/articles/Hierarchy/94040/