Ever wonder how to select what columns need to be in an index definition and what columns should be in the INCLUDE clause. This session will take a deep dive in looking at two SELECT queries on the AdventureWorks2017 database and what indexes give the best, adequate, and poor performance and their relation to disk space utilization.

A Rocket Scientist Perspective on Index Column Selection - SQL Server Virtual Co...
Feb 01 2021

CSharp TV

This session is about “ A Rocket Scientist Perspective on Index Column Selection ”in SQL Server Virtual Conference 2021.