Continuation from the previous 89 parts, the whole series can be found at https://www.nikoport.com/columnstore/. This blog post is focusing on a very important improvement to the limitation of the In-Memory Columnstore Indexes that was existing in SQL Server 2016, but…
This is the most important blog post about SQL Server that I have ever written. As far as I am concerned this is the most epic moment in the history of the SQL Server since its inception (yeah, you could…
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.…