SQL Server Clustered Index Btree Traversal
–Brought to you as a script! Enjoy –� 2017 | ByrdNest Consulting –Index B-Tree Analysis /************************************************************************************ This script explores clustered, unique-nonclustered, and nonclustered indexes at the page level. Most likely the page ids used here will change in your database configuration and setup — mine rarely used same page ids even with repetitive usage. However, […]
Read More