It is time. I have been thinking about this for about a year and playing with the idea for way too long, with the concrete plans for the January of 2018, than August 2018 … Anyway – here we go…
Columnstore Indexes – part 127 (“Batch Mode on Rowstore – is it a Columnstore Killer?”)
Continuation from the previous 126 parts, the whole series can be found at https://www.nikoport.com/columnstore/. With the appearance of the Batch Mode on the Rowstore Indexes (FINALLY!), the big question (aka Elefant) is in the room – DO WE STILL NEED…
Batch Mode – part 2 (“Batch Mode on Rowstore in Basics”)
This blog post is a part of the whole Batch Mode series, which can be found at the Nikoport Batch Mode page. With the initial public CTP release of the SQL Server 2019 – the CTP 2.0 we have finally…
Columnstore Indexes – part 126 (“Extracting Columnstore Statistics to Cloned Database”)
Continuation from the previous 125 parts, the whole series can be found at https://www.nikoport.com/columnstore/. I have a huge love for the DBCC CLONEDATABASE command – it has been made available (backported) to every SQL Server version starting with SQL Server…
Columnstore Indexes – part 125 (“Estimate Columnstore Compression as a System Stored Proc”)
Continuation from the previous 124 parts, the whole series can be found at https://www.nikoport.com/columnstore/. It is quite emblematic that this blog post is following the number 124 in the series – Columnstore Indexes – part 124 (“Estimate Columnstore Compression”), because…