Columnstore Index – How to Estimate Compression Savings

SQL product team has made significant improvements in columnstore index functionality, supportability and performance during SQL Server 2016 based on the feedback from customers. Please refer to  List of Blogs  for all blogs published by SQL Tiger Team on columnstore index. Issue When SQL Server team released ROW and PAGE compression in SQL Server 2008,…

2

Columnstore Index – List of blogs on columnstore index published by SQL Server Product Team

SQL product team has made significant improvements in functionality, supportability and performance of columnstore indexes during SQL Server 2016. These improvements were prioritized based on the feedback by customer who had used columnstore index functionality in prior releases. SQL Server product team has created a large set of blogs across multiple columnstore index scenarios. This blog consolidates the…

1

Columnstore Index: SQL Server 2016 – Improved DMV performance

SQL product team has made significant improvements in columnstore index functionality, supportability and performance in SQL Server 2016 based on the customer feedback. This blog post focuses on the performance improvements on a DMV done as part of our latest servicing release of SQL Server 2016, SQL Server 2016 SP1 CU1 and SQL Server 2016 RTM CU4. For…


Columnstore Index Performance: SQL Server 2016 – Window Aggregates in BatchMode

SQL product team has made significant improvements in columnstore index functionality, supportability and performance during SQL Server 2016 based on the feedback from customers. This blog series focuses on the performance improvements done as part of SQL Server 2016. Please refer to one of the blogs No performance cliff for details on the database used for…

0

Columnstore Index Performance: SQL Server 2016 – String Predicate Pushdown

SQL product team has made significant improvements in columnstore index functionality, supportability and performance during SQL Server 2016 based on the feedback from customers. This blog series focuses on the performance improvements done as part of SQL Server 2016. Please refer to one of the previous blogs No performance cliff for details. The topic of this…

1

Columnstore Index Performance: SQL Server 2016 – Aggregate Pushdown

SQL product team has made significant improvements in columnstore index functionality, supportability and performance during SQL Server 2016 based on the feedback from customers. This blog series focuses on the performance improvements done as part of SQL Server 2016. Please refer to previous blog No performance cliff  in this series for details. Aggregates are a very common construct…

4

Columnstore Index Performance: SQL Server 2016 – No Performance Cliff

SQL product team has made significant improvements in columnstore index functionality, supportability and performance during SQL Server 2016 based on the feedback from customers. This blog series focuses on the performance improvements done as part of SQL Server 2016. Customers will get these benefits automatically with no changes to the application when they upgrade the application…

2

Columnstore Index Performance: BatchMode Execution

In the blog Industry leading analtyics query performance,  we had looked into how SQL Server delivers superior analytics query performance with columnstore index. Besides significant reduction in IO, the analytics queries get order of magnitude better performance boost with BatchMode processing, a unique value proposition in SQL Server. The basic idea of batch mode processing is…

0

Columnstore Index Performance: Rowgroup Elimination

As described in Column Elimination , when querying columnstore index, only the referenced columns are fetched. This can potentially reduce IO/memory footprint of analytics queries significantly and speed up the query performance. While this is good, the other challenge with columnstore index is how to limit the number of rows to be read to process…

2