Troy Ketsdever, a colleague at Configuresoft, will be presenting a couple of sessions next week (March 5-6, 2008) at Colorado PASS Camp.
PASS Camp is a free, information-packed day of practical SQL Server training and information. There will be a total of 32 sessions on a wide range of interesting topics plus an opening Keynote for each day. PASS Camp sessions are short, to the point, and filled with code and actual hands-on demonstrations to maximize the value to you, our peers in the SQL Server community.
Matrix Path Encoding
A new method of representing hierarchies in SQL Server. The basis for the representation involves numeric assignment/substitution for the path elements, and then encoding them using 2x2 matrices.
Comparing and Contrasting Designs for Hierarchy Representation in T-SQL
Starting with brief review of various proposed models for representing hierarchies in SQL Server (including SS2K8's new HierarchyID), we will characterize different information patterns and assess the pros and cons of each design against various criteria. After studying reference examples, we end with a summary of our findings in a "hierarchy scorecard" matrix.
Published February 26, 2008
Technorati Tags: SQL Server