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…
CISL 1.4.0 is released
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…
Columnstore Indexes – part 87 (“Indexed Views”)
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…
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…