Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Hierarchyid Data Type -- Pros and Cons? Expand / Collapse
Author
Message
Posted Friday, August 24, 2012 9:09 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, August 9, 2013 3:52 PM
Points: 430, Visits: 448
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.
Post #1349734
Posted Friday, August 24, 2012 9:12 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 13,872, Visits: 9,596
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
Post #1349738
Posted Monday, August 27, 2012 7:48 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, August 9, 2013 3:52 PM
Points: 430, Visits: 448
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.
Post #1350389
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse