SQL Server 2005 - Left/Right Tree Analysis
Feb 2008 - Current (18 years 9 months)
An analysis of the various storage/retrieval methods for hierarchical data in SQL Server 2005. The analysis includes sample code for various storage and retrieval methods along with a comparison of resulting execution times. The focus of the analysis was data retrieval since the primary purpose for the analysis was to determine which method provided the optimal speed for supplying data to a reporting engine.