To this effect, they have introduced the HierarchId data type in SQL Server 2008. In traditional hierarchies, a row merely stores a reference to its parent node.