With the release of the most epic Service Pack 1 for SQL Server 2016, the biggest attention of everyone should be drawn to the programmability surface that was brought on the same level for Enterprise, Standard, Web & Express Edition!…
Announcing Preview Release of MOSL
The MOSL – Memory Optimised Scripts Library has finally received a first public preview release – the version 0.2.0! This version introduces the initial support for Memory Optimised Objects on SQL Server 2014 & SQL Server 2016. The biggest difference…
Launching Columnstore.NET
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…
CISL 1.4.0 is released
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…
Columnstore Indexes – part 89 (“Memory-Optimised Columnstore Limitations 2016”)
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.…