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, …). 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, …).