Continuation from the previous 32 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ We all love and use Columnstore Segments, but we all kind of scared of the open Delta-Stores (yes there can be more than 1). Why would that be? – because they…
Achievement unlocked. I am more than delighted to announce that I was selected to speak at the upcoming PASS Summit 2014 in November of 2014 in the beautiful city of Seattle. Every Microsoft Data Platform professional, every Microsoft Employee doing…
Continuation from the previous 31 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ The Columnstore Row Group Size Question: What is better for SQL Server performance: to have a big Row Groups (1.045.678 rows) or to have them as small as possible (100.000 rows)…
Continuation from the previous 30 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ This blog post is focusing on one of the most important real world issues – Memory Pressure. While testing on your own Computer or on some development server in a controlled…
Continuation from the previous 29 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ It has been a long time (almost a year) since Microsoft revealed the public preview version of SQL Server with Clustered Columnstore Indexes available, and ever since there were hundreds of…