Our next meeting is on 11/14/2019. Reservations can be made on the
Eventbrite page.
Hierarchies on Steroids
Hierarchical data sets are everywhere. If you haven't worked with one yet, you probably will someday. If you're already working with them, you know they can be horribly complex, slow performing, difficult to maintain resource hogs that can really take the steam out of any GUI or batch process.
This simple but code intensive "Black Arts" session shows you how to quickly and easily get around all of that using all 3 common hierarchical structures and includes a very high performance method (100,000 nodes in less than 4 seconds and 1 Million nodes in less than a minute) for converting Adjacency Lists to Nested Sets that even a beginner can understand
If there's time, we'll cover a new "pre-aggregated" Hierarchical table structure that answers most of the questions you'd ask of a Hierarchy. You just have to know that a Tally Table is involved somewhere in this. ;-)
Don't let the "Intermediate" rating of this session scare you beginners away because we start at the ground floor.
Speaker Bio: Jeff Moden
With more than 50,000 posts and 3 dozen mostly 5 star articles, Jeff Moden is the leading forum poster and a strong contributor on SQLServerCentral.com where he coined the term “RBAR” (Row By Agonizing Row) and helped make the "Tally Table" a household name. Jeff has more than 2 decades of experience with SQL Server and is mostly self-trained in what he calls the “Black Arts” of T-SQL. He’s known worldwide for his informative articles, high performance T-SQL coding methods, and methods of mentoring. His dedication to helping others earned him the MS SQL Server MVP award for nine years and the RedGate Exceptional DBA Award in 2011. His mantra is "Performance is in the code".