Sys-Dm_db_database_page_allocations

Tag: sys-dm_db_database_page_allocations

Indexes: Do Included Columns Always Go on a Non-Root Page? (video)

on May 10, 2016

Category: indexing

Recently, I was thinking about nonclustered indexes in SQL Server, and how included columns are stored.

Is SQL Server smart enough to optimize the storage for small indexes with includes? Find out in this free seven minute video.

Copyright (c) 2025, Catalyze SQL, LLC; all rights reserved. Opinions expressed on this site are solely those of Kendra Little of Catalyze SQL, LLC. Content policy: Short excerpts of blog posts (3 sentences) may be republished, but longer excerpts and artwork cannot be shared without explicit permission.