Browsing All Posts published on »February, 2011«

Nested Set Hierarchy

February 14, 2011

2

Another method of modeling hierarchies in SQL, is the Nested Set method created by Michael J. Kamfonas and made popular by Joe Celko. I’ve implemented this method in the past and through testing have found it to be extremely performant. This method involves creating left and right values for each member in the hierarchy. Then […]

Populating a many-to-many bridge table pt2

February 1, 2011

1

I have been testing the previous example code (see https://jsimonbi.wordpress.com/2011/01/25/populating-a-many-to-many-bridge-table/) to populate a many to many bridge table with a large dataset and wasn’t happy with the performance. So I’ve  gone back to the drawing board on how to do this. I wanted a set based solution, and something that was both simple and efficient. To recap, if […]