Search

Home > GroupBy – Free SQL Server Training > Successful Production Deployments with Columnstore Index in SQL Server 2016 with Sunil Agarwal
Podcast: GroupBy – Free SQL Server Training
Episode:

Successful Production Deployments with Columnstore Index in SQL Server 2016 with Sunil Agarwal

Category: Technology
Duration: 01:22:29
Publish Date: 2017-08-29 05:00:00
Description:

Imagine your Data Warehouse is growing exponentially to multi-terabytes and you have been tasked to make analytics queries even faster while keeping the cost of storage low. Industry leading SQL Server 2016 columnstore technology can help you solve these by reducing the storage footprint by 10x (average) and speed up analytics queries up to 100x. SQL Server Tiger team has leveraged columnstore technology with many Tier-1 workloads to achieve these goals. This session will cover three different types of workload. For each workload, we will cover the application architecture, challenges and how SQL Tiger team used columnstore index technology to address them.

Total Play: 0