Managing hierarchies in Information Systems has long been a challenge to most information systems professionals. The issues are simple, but the
implementation of hierarchies within databases is complex and often onerous.
The HierarchyID datatype introduced in SQL Server 2008 provides a new way to deal with these types of issues.
In this video, Max Adams will introduce this new HierarchyID Datatype and examine how to:

• Create tables that implement this datatype
• Populate the table with data using CTE
• Query the table using some of the inherent functions available for the HierarchyID Datatype

Presented by Max Adams http://maxmusings.spaces.live.com
Length: 14 minutes 32 seconds

If you've installed Silverlight, click the Play button in the video player at left.

Video Downloads
WMV (Zip) | WMV | MP4 | iPod | 3GP | Zune | PSP

Audio Downloads
AAC | WMA | MP2 | MP3 | MP4