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…
One of my favourite conferences (and so far I was incredibly lucky to have spoken at every edition) is SQLKonferenz, which is a middle-range sized conference, located in Darmstadt, Germany. Sized at 400-500 people, it is not the biggest conference…
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…