Jeff Moden

  • Interests: SQL. When Im not having fun with that, then SQL. ;-)

Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations

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?

4.93 (27)

2012-11-15

14,138 reads

Blogs

Daily Coping 17 Sep 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Ethics in Modern Data at Music City Tech 2021

By

  On Sept 16, Christine and I presented our joint presentation on Ethics in Modern Data at...

Slides and Video from Building a Regret-free Foundation for your Data Factory Now Available

By

Last week, Kerry and I delivered a webinar with tips on how to set...

Read the latest Blogs

Forums

SQL Agent job

By Chitown

Can I run extended event session against 1 SQL agent job? I have a...

Need some help with tsql code

By Chitown

I have 4 tables (DevDB, TestDB, StageDB, ProdDB). All those tables have 2 columns...

Save Blob Storage Key in Package

By alex.sqldba

Hi Guys, Is there a way to save the Blob Storage Key into a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers