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