Modeling hierarchical domains

Check out this article by the Microsoft SQL Server Development Customer Advisory Team on a good approach to model hierarchies in SQL Server.

Application Patterns and database performance: Academically correct object modeling