Performance Comparison of SQL Server 2016 Columnstore Indexes
for Real-Time Operation Analytics with In-Memory Optimized Tables in Azure
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