Hierarchyid Data Type -- Pros and Cons?

  • 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.

  • 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

  • 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