SQL Server 2008 - HierarchyID - OMG!


	SQL Server 2008 - HierarchyID - OMG!

travislaborde

8-31-2007 8:33 AM

926 views

tags:

programming, sql server

travislaborde says:

OK, SQL Server 2008 is looking like THE BOMB!

Add a Comment

Login to Comment. Not a member yet? Sign up

More clips from travislaborde

Astronomy Picture of the Day: The Colors of I...

DO SMOKING GUNS CAUSE GLOBAL WARMING, TOO?

Astronomy Picture of the Day: NGC 6992: Filam...

Today's Top Clips

visit the Top Clips page

View the Top Clips from August 31, 2007

Embed This Clip In Your Site...

<div style="margin: 12px 0px; font-family: arial; color: #333333; background: #ffffff; border: solid 4px #e5e5e5; width: 100%; clear: left;"><div class="CM_CTB_Content_Wrap" style="margin: 0px; padding: 0px;background-color: #ffffff;"><div style="border-bottom: solid 1px #dcdcdc; white-space: nowrap; margin-bottom: 8px; background-color: #eeeeee ;background-image: url(http://www.clipmarks.com/images/source-bg.gif); background-repeat: repeat-x; height: 24px; line-height: 24px; vertical-align: middle; padding-bottom: 4px; color: #666666; font-size: 10px;" ><a href="http://clipmarks.com/clip-to-blog/" title="see clips that are hot right now"><img src="http://content.clipmarks.com/blog_embed/a8e8dd36-ff15-4f35-aead-69d3c529a382/B088B2B7-4281-4479-B55E-C3F0AFA934CA/" alt="" width="19" height="19" border="0" style="vertical-align: middle; margin: 0px 4px; display: inline; border: none; float:none;" /></a>clipped from <a title="http://blogs.msdn.com/manisblog/default.aspx" href="http://blogs.msdn.com/manisblog/default.aspx" style="font-size: 11px;">blogs.msdn.com</a></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://blogs.msdn.com/manisblog/default.aspx"><H5 class="posthead">
                        <A href="http://blogs.msdn.com/manisblog/archive/2007/08/17/sql-server-2008-hierarchyid.aspx" id="bp___v___r___postlist___EntryItems_ctl02_PostTitle">SQL Server 2008 - HierarchyID - Part I</A> 
                    </H5></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://blogs.msdn.com/manisblog/default.aspx"><P>I am excited by the cool new features that SQL Server 2008 is binging up !</P></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://blogs.msdn.com/manisblog/default.aspx"><P>SQL Server 2008 is bringing some commendable new features one of the nice feature is <STRONG>HierarchyID</STRONG>. This a new data type that is available in the in the latest July CTP of the SQL Server 2008 Developer Edition.</P></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://blogs.msdn.com/manisblog/default.aspx"><P>Organizations have struggled in past with the representation of tree like structures in the databases, lot of joins lots of complex logic goes into the place, whether it is organization hierarchy or defining a BOM (Bill of Materials) where one finished product is dependent on another semi finished materials / kit items and these kit items are dependent on another semi finished items or raw materials.</P></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://blogs.msdn.com/manisblog/default.aspx">SQL Server 2008 has the solution to the problem where we store the entire hierarchy in the data type HierarchyID. </blockquote></div><div style="margin: 0px 6px 6px 4px;"><table style="font-size: 11px;border-spacing: 0px;padding: 0px;" cellpadding="0" cellspacing="0" width="100%"><tr><td style="background:transparent;border-width:0px;padding:0px;">&nbsp;</td><td align="right" style="background:transparent;border-width:0px;padding:0px;width:107px" width="107"><a href="http://clipmarks.com/share/B088B2B7-4281-4479-B55E-C3F0AFA934CA/blog/" title="blog or email this clip"><img src="http://content8.clipmarks.com/images/c2b-foot.png" border="0" alt="blog it" width="107" height="17" style="border-width:0px;padding:0px;margin:0px;" /></a></td></tr></table></div></div>

New from the makers of Clipmarks: Amplify.com - Don't just share the news...Amplify it!

Clipmarks: Home; New Clips; Top Clips; Dashboard

Popular Topics: News; Life; Science; Technology; Entertainment

Get Started: Sign Up; Install Clipping Tool; How Clipping Works; Clip-to-Blog™; ClipSearch

Tools and Resources: FAQ; ClipWeek; Top Clippers; Top Tags; Site Map

About Clipmarks: About Us; Contact; Copyright; Privacy; EULA

Search Options

More clips from travislaborde

Today's Top Clips