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)

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

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.

Continue reading