embed embed share link link comment comment

Embed This Video close
Share This Video close
bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark
embed test
Rate This Video embed
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...
Tags For This Video tags
rate rate tags tags related related lights lights

HierarchyID CLR Data Type


Michael Kappel


Microsoft SQL Server 2008 HierarchyID CLR Data Type Presentation. Michael Kappel talks about HierarchyIDs including what they are, how to use them, when to use them, and also when not to. Microsoft has made implementing parent-child relationships faster and simpler to implement successfully through the new native support of hierarchical data in SQL Server 2008. The HierarchyID is a common language runtime (CLR) data type and because of this Microsoft was able to build in a number of methods to make traversing nodes simple. Initial setup and configuration of the HierarchyID data type can seem tricky and confusing at first. Especially with real work situations like having multiple root nodes or both branch and root nodes simultaneously. In this demonstration I will setup and implement standard node branching as well as Multi-root and tree branch/root combinations for advanced hierarchical data scenarios. HierarchyID is a powerful solution to Parent, Child, Ancestor, Descendent, and Sibling data management. The true genius of the HierarchyID data type is simple and flexible design that is shockingly fast in node related quires.


Michael Kappel is a professional “problem solver” with a demonstrable track-record of producing significant deliverables as a leader, an individual contributor, and a valuable member of a successful team. With over twelve years of internet application development experience, he is capable of understanding business and technical needs, making recommendations, and providing technical know-how, leadership, and vision to even the most complex of software development projects.

Recorded At:

CITAG the Chicago Information Technology Architects Group http://chicagoarchitectsgroup.com/

Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>