Hierarchies in SQL, Part II, the Sequel
Posted
on SQL Server Central
See other posts from SQL Server Central
Published on Tue, 21 Aug 2012 06:00:00 UT
Indexed on
2012/09/01
21:45 UTC
Read the original article
Hit count: 241
Filed under:
In a followup to his first article on Hierarchies, Gus Gwynn takes a look at the performance of a few different methods of querying a hierarchy. Learn how the HierarchyID stacks up.
Are you sure you can restore your backups? Run full restore + DBCC CHECKDB quickly and easily with SQL Backup Pro's new automated verification. Check for corruption and prepare for when disaster strikes. Try it now. |
© SQL Server Central or respective owner