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