Post reply

Hierarchyid Data Type -- Pros and Cons?

  • August 24, 2012 at 9:09 am

    #280780

    For a new application and database model, our team is trying to decide whether to use the hierarchyid data type. Would appreciate any feedback, pros and cons, from anyone who has implemented it.

  • August 24, 2012 at 9:12 am

    #1529793

    Here's some of what I found on it: http://www.sqlservercentral.com/articles/T-SQL/92461/

    The discussion (short), has a little information beyond what's in the article.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • August 27, 2012 at 7:48 am

    #1530348

    Thanks for pointing me to the articles. We're still debating whether to go with the new syntax and non-ANSI SQL, but you added some valuable information.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply