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.…
Columnstore Indexes – part 88 (“Minimal Logging 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…
MOSL – Memory Optimised Scripts Library
SQL Server 2014 was one amazing release, which had a very interesting codename – “Hekaton”, meaning that the principal news in that release were the Memory-Optimised tables (aka In-Memory, aka In-Memory OLTP aka Hekaton) and even though for me personally…
Columnstore & Memory-Optimised Workshop in Redmond (10.31-11.02 2016)
I am so happy that I can finally announce the very first Columnstore & Memory-Optimised Tables Workshop in the USA: on the 31st of October 2016 the Columnstore & Memory-Optimised Workshop will take place in Redmond, Washington! This workshop will…