This blog is a kick-off the series that will be dedicated to the graph databases and engines, being more specifically focused on the SQL Graph, that is the newest extension to the SQL Server engine, as well as the Azure…
SQL Graph, part I
Columnstore Indexes – part 106 (“Memory Requirements for Rebuild & Reorganize”)
Continuation from the previous 105 parts, the whole series can be found at https://www.nikoport.com/columnstore/. One of the most important and recurring topics for any type of indices is their Building/Rebuilding/Reorganzing processes – after all we do load more data into…
Columnstore Indexes – part 105 (“Performance Counters”)
Continuation from the previous 104 parts, the whole series can be found at https://www.nikoport.com/columnstore/. For a very long time I was intending to write some of the unsung & almost hidden improvements of the SQL Server 2016 – the performance…
Columnstore Indexes – part 104 (“Batch Mode Adaptive Joins”)
Continuation from the previous 103 parts, the whole series can be found at https://www.nikoport.com/columnstore/. This blog post is a logical continuation of the blog post that I have published in December 2016 – Columnstore Indexes – part 93 (“Batch Mode…
Columnstore Indexes – part 103 (“Partitioning 2016 vs Partitioning 2014”)
Continuation from the previous 94 parts, the whole series can be found at https://www.nikoport.com/columnstore/. I have been wanting to write on this topic for quite some time, but with all the exciting themes that I have on my todo list…