Continuation from the previous 95 parts, the whole series can be found at https://www.nikoport.com/columnstore/. This blog post is focused on a very important feature in the modern times of the real time operations – the online operations. The first online…
Columnstore Indexes – part 92 (“Lobs”)
Continuation from the previous 91 parts, the whole series can be found at https://www.nikoport.com/columnstore/. Since the very first version of the Columnstore Indexes in 2012, there has been no support for LOB (large objects binaries). The reason behind not focusing…
Columnstore Indexes – part 90 (“In-Memory Columnstore Improvements in Service Pack 1 of SQL Server 2016 “)
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…
SQL Server 2016 SP1 – Programmability Surface for everyone!
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…
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…