I began looking today at new features planned for SQL Server 2008. One that caught my eye is new support for tree-structured data in the form of a new, built-in data type called hierarchyid that allows representation of parent/child relationships without the need for recursive, foreign keys. For example, rather than use the following, common approach to representing the manager/employee relationship:
Click here to read more

