SQLBits 2012

Luke I’m your father - Hierarchies in SQL Server

Hierarchies are the bread and butter of most business applications (departmental diagram, product categories, sales territories, calendar, …). See typical business problems and how they are solved in SQL Server.
Hierarchies are the bread and butter of most business applications (departmental diagram, product categories, sales territories, calendar, …). Markus offers insights into best practice through typical business problems in his samples (e.g. hierarchy through different tables, parent-child-hierarchy, datatype hierarchieID, hierarchy as slowly changing dimension, hierarchy in LINQ and MDX, …).