This blog post is a continuation in the little series about CosmosDB, that is started with the post CosmosDB: NoSQL, NoDBA & NoProblem? In this blog post I am going to research some common way of viewing about the default…
CosmosDB: NoSQL, NoDBA & NoProblem?
Welcome to my series on the CosmosDB, you might enjoy them, or you might not. :) This represents my current opinion and view on this platform at this very moment and it might change in the future (given that 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…
Resumable Online Index Rebuild
I have been fascinated with another new feature of the upcoming SQL Server release and so I decided to blog about it. The new version of SQL Server (2017) introduces a very exciting feature for the DBA’s – the Resumable…