Select Page

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 World

SQL 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.

Read The Presentation Here

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.


Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.