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…
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…