Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Daily SQL Server 2008 New Feature – Day 20

Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply for awareness. You can then go away and research the area and report back to me, we’ll then discuss how these new features can benefit us all.

 Thursday June 10th 2010

HierarchyId

Enable database applications to model tree structures in a more efficient way than currently possible. New system type HierarchyId can store values that represent nodes in a hierarchy tree. This new type will be implemented as a CLR UDT, and will expose several efficient and useful built-in methods for creating and operating on hierarchy nodes with a flexible programming model.

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.