Tagged Questions

0
votes
0answers
41 views

Hierarchical data best practices

I'm looking for a best practicies\databases to solve our problem: Currently we are using SQL Server 2008 R2 with HierarchyId. It works ok, but we have a lot of performance penalties due to this ...
9
votes
2answers
179 views

Is there a set based way to load/read a tree branch with HierarchyId

I am playing around with HierarchyId, and I have not figured out a set based way to do the following: insert all subtree at once retrieve all subtree at once This question is related to my ...