indexing

Successful production deployments with columnstore index in SQL Server 2016

Audio podcast: Enjoy the Podcast? Don’t miss an episode, subscribe via iTunes, Stitcher or RSS Leave us a review in iTunes Target Audience: Architects and DBAs Abstract: 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…
Read More

Worst Practices & Less Known Limitations for Columnstore Indexes

Audio podcast: Enjoy the Podcast? Don’t miss an episode, subscribe via iTunes, Stitcher or RSS Leave us a review in iTunes Target Audience: Database Administrators, SQL Architects, Developers who write queries, BI Devs working with ETL. Abstract: Have you ever considered a situation where Columnstore Index can be quite the opposite of what one would…
Read More
Menu