Presentation

Performance Comparison of SQL Server 2016 Columnstore Indexes

for Real-Time Operation Analytics with In-Memory Optimized Tables in Azure

DBA Role Shift in a DevOps WorldSQL Server 2016 has introduced Columnstore indexes that can be used for Real-Time operational analytics. This is the first time Columnstore indexes will be available for OLTP databases alongside In-Memory optimized tables.

This presentation will first compare and contrast the use of SQL Server 2016 Columnstore indexes for Real-Time Operational Analytics with In-Memory Optimized Tables. A performance comparison will then be performed between the two types of in-memory index structures in Azure.

The performance comparison will show when it is best to use each type of in-memory index structure.

Learn more by downloading Datavail’s presentation today >>