SQL Server for Developers

SQT07 Conquering Columnstore Indexes


2:45pm - 4:00pm

Level: Intermediate to Advanced

Tim Chapman

Principal Solution Architect


Introduced in SQL Server 2012, Columnstore Indexes have the power to completely transform a reporting environment. These indexes offer a solution for your reporting workload with an order of magnitude better data compression and query performance over traditional tables and indexes. SQL Server 2016 significantly enhanced these indexes so that you can take advantage of them with your OLTP workload to enable something known as Operational Analytics. This session will dig into what Columnstore Indexes are, how they are implemented, and the advantages of using this incredibly useful feature.

You will learn:

  • Understand what a Columnstore Index is
  • Understand when to use Columnstore Indexes vs B-Tree Indexes
  • Analytics Queries using Columnstore Indexes