The PASS Data Architecture Virtual Group focuses on data architecture concerns as they impact users, developers and DBAs on the Microsoft SQL Server platform.

Login to Subscribe

Meeting Details

How Keys & Included Columns Work by Kendra Little

Wed, Jun 13 2018 18:00 UTC

How Keys & Included Columns Work

Learn how disk-based rowstore indexes are structured in SQL Server. Why can you seek on key columns? Where are included columns stored, and how can you use them? In this demo-based webcast, we'll use undocumented commands in SQL Server to explore the secrets in a real disk-based rowstore index.


Kendra Little

Kendra Little is a Microsoft Certified Master and a Microsoft MVP. Kendra fell in love with the challenge of deploying software to a complex database environment when she worked in a build operations team at a software startup. She went on to become a database administrator for performance critical databases at Microsoft Corporation. Since then, Kendra has worked internationally as a teacher and consultant, and founded the training site SQL Workbooks. She joined Redgate as a Product Evangelist in 2018.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids