Hierarchyid Data Type -- Pros and Cons?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Hierarchyid Data Type -- Pros and Cons?

Hierarchyid Data Type -- Pros and Cons?

Rate Topic

Display Mode

Topic Options

Author

Message

MelS-512196

Posted Friday, August 24, 2012 9:09 AM

SSC-Addicted

Group: General Forum Members
Last Login: Wednesday, April 10, 2013 10:30 AM
Points: 426, Visits: 445

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

GSquared

Posted Friday, August 24, 2012 9:12 AM

SSCoach

Group: General Forum Members
Last Login: Monday, May 06, 2013 1:09 PM
Points: 15,439, Visits: 9,569

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

MelS-512196

Posted Monday, August 27, 2012 7:48 AM

SSC-Addicted

Group: General Forum Members
Last Login: Wednesday, April 10, 2013 10:30 AM
Points: 426, Visits: 445

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 »

Permissions