THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Louis Davidson

SQL Saturday Nashville: I'm Speaking

Going home y'all. On January 13th, I will be speaking at the Nashville SQL Saturday. I moved from Nashville less than 1 year ago, and I always look forward to making a trip up (and not just for hot chicken at Big Shakes, though it does figure into it.) Tamera Clark and team always do a great job, and the list of speakers that I get to hear and hang out with is pretty awesome.

My topic and abstract are:

How to Implement a Hierarchy in SQL Server
One of the most common structures you will come across in the real world is a hierarchy (either a single parent "tree" or a multi-parent "graph"). Many systems will implement the obvious examples, such as a corporate managerial structure or a bill of materials. It turns out that almost any many-to-many relationship can be used as a hierarchy to find the relationship of parent rows to child rows (for example, the relationship of actors to movies they’ve been in). In this session, we’ll discuss several different implementations of hierarchies that you can use to optimize your hierarchy implementations, including SQL Server 2017's graph tables, and put into practice immediately, with ready-made T-SQL examples.

Note: This is a session I did at the Freecon before the SQL Summit, and it is a lot of information in an hour. I will cover, conceptually, multiple ways to implement a hierarchy in SQL Server code, and then demonstrate the simplest method using what is known as an adjacency list. I stick to the adjacency list because it is a foundational for using the new graph tables in SQL Server 2017, which I will also demonstrate.

If you haven't registered already, head over to: and make it happen. If you can, there are 7 precon sessions spread across two days with speakers like Kevin Kline, Catherine Wihelmsen, Jason Horner, John Deardruff, John Sterrett, Ben Miller, and Josh Luedeman. All people I would go an hear for a day if I had time to.

Published Wednesday, January 3, 2018 9:03 PM by drsql

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS


No Comments

Leave a Comment


This Blog


Links to my other sites


Privacy Statement