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
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
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 Thanks Sunil Agarwal SQL Server Tiger Team ... continue reading
I am sure you all have heard the exciting news that SQL Server 2016 SP1 supports Common Programming Surface Area (CPSA) across all features. And, YES, that includes columnstore index. Please refer to the following blog for details Columnstore Index: ... continue reading
Columnstore Index: Why do I need to create clustered columnstore Index on In-Memory OLTP- tables for Analytics?
Please refer to this blog under MSSQL Tiger Team blog site Columnstore Index: Why do I need to create clustered columnstore Index on In-Memory OLTP- tables for Analytics? Thanks Sunil Agarwal ... continue reading
Please refer to my blog under MSSQL Tiger Team blogs In-Memory OLTP: Is your database just in memory or actually optimized for memory? Thanks Sunil Agarwal ... continue reading