I am so glad that the time has arrived to announce my next project – the Columnstore.NET! This site will incorporate all useful information on the Columnstore Indexes & Batch Execution Mode, including blog posts (from different sources), presentations, case…
Another happy release of the CISL (Columnstore Indexes Script Library) is live – this time it is 1.4.0! This release is focusing on the addition of the Extended Events, so that a user of CISL can easily set up the…
Continuation from the previous 88 parts, the whole series can be found at https://www.nikoport.com/columnstore/. I would like to dedicate this blog post to the Memory-Optimised (also known and LOVED as Hekaton) Columnstore Indexes and their limitations in SQL Server 2016.…
Continuation from the previous 87 parts, the whole series can be found at https://www.nikoport.com/columnstore/. Getting Data into the Database is one essential process, no matter if you are working with an OLTP application or if you are a professional Data…
Continuation from the previous 86 parts, the whole series can be found at https://www.nikoport.com/columnstore/. A very long time desired feature from my side was something that I have described in the Connect Item – allowing calculation measures on the row…