Continuation from the previous 116 parts, the whole series can be found at https://www.nikoport.com/columnstore/ An important issue I have faced already a couple of times in production servers was the usage of the Nonclustered Columnstore Indexes vs the usage of…
Continuation from the previous 115 parts, the whole series can be found at https://www.nikoport.com/columnstore/ After delaying for a couple of years (yes, strangely there is other priority in my life, besides this blog post series) – I am finally putting…
Continuation from the previous 114 parts, the whole series can be found at https://www.nikoport.com/columnstore/. This blog post is dedicated to the Bulk Load API and the sudden changes that might take place and affect it during the loading process into…
Continuation from the previous 113 parts, the whole series can be found at https://www.nikoport.com/columnstore/. This blogpost is focusing on the unsung (and at the moment undocumented) improvement that is connected to the Columnstore Indexes, the communication between SQL Server relational…
Continuation from the previous 112 parts, the whole series can be found at https://www.nikoport.com/columnstore/. This blog post serves as the continuation of the original blog post on the Row Group Merge functionalities that I have described in Columnstore Indexes –…