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…
Every IT person is more than introduced to the problems of integration – in the ideal perfect world we could join any 2 or more given data sources together, while in the real world it might the biggest pain in…
It has been quite some time, that the term Modern Data Warehouse has appeared on the horizon of so many data professionals and publications around the world. Some people describe this term as a conjunction of many different types of…
Continuation from the previous 28 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ One of the key performance factors for Columnstore Indexes is Segment Elimination. I have been presenting on this matter for quite a while, but never actually blogged about it. Every Columnstore…