Greater Lansing Area for SQL Server (GLASS)

Greater Lansing Area for SQL Server

We are a group of professionals who like to get together to talk about Microsoft SQL Server and related technologies. Meetings are open and free of cost to the public but will require an RSVP so we can get an accurate count for food. 


1. Facilitate networking and create opportunities for our members
2. Deliver quality content for in-depth learning and professional development
3. Encourage community growth and development

Contact Information

1. Mailing list signup:
2. Twitter:
3. LinkedIn:


Next Meeting




Hierarchies... On Steroids

  • In-Person @ Lansing, Michigan, United States (map)
  • 17:30 - 19:30 Eastern Daylight Time
  • Language: English

Hierarchies… on Steroids
By Jeff Moden (90 minutes)

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.

We'll also 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 advanced nature of this session scare you beginners away because we start at the ground floor and work our way up.

Speaker Bio

With more than 44,000 posts and 3 dozen 5 star articles, Jeff Moden is a strong contributor on where he coined the term “RBAR” (Row By Agonizing Row). 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".

Jeff was also the first speaker for this group and has presented on every April anniversary of the group. He continues that tradition with this April 2018 presentation of “Hierarchies… on Steroids”.

Supplementary Materials

The following event attachments are available to you:



Back to Top