SQL Server Index Keys, Included Columns, and Page Count

Learn how SQL Server stores key and included columns, and whether or not it’s smart enough to optimize the storage of small nonclustered indexes.