One of the coolest and fantastic new features of SQL Server 2008 is the new data type HierarchyID. Asaf Aviv explains all about it. http://www.madeira.co.il/the-new-data-type-hierarchyid-is-one-of-the-coolest-and-fantastic-new-features-of-sql-server-2008/