Select Page
hidden-column

Clustered Columnstore Index: Massively Parallel Trickle Insert

A traditional scenario of loading data into CCI is a nightly load from one or more data files containing millions of rows. Recommended technique is to load the data with batchsize >= 102400 as explained https://blogs.msdn.microsoft.com/sqlserverstorageengine/2014/07/27/clustered-column-store-index-bulk-loading-the-data/. However, we are seeing ... continue reading

Columnstore Index Performance: SQL Server 2016 – Multiple Aggregates

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 ... continue reading

Columnstore Index Performance: Batch Mode Execution

Just posted the following blog as part of SQL Tiger team blog. I will continue with this series with many other performance specific changes done in SQL Server 2016 Columnstore index Performance: BatchMode Execution Thanks Sunil Agarwal ... continue reading

Columnstore Index Performance: Rowgroup Elimination

Columnstore Index Performance: Rowgroup Elimination Thanks Sunil Agarwal SQL Server Tiger Team ... continue reading