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 –…
Continuation from the previous 111 parts, the whole series can be found at https://www.nikoport.com/columnstore/. This blogpost is focusing on the Server Object functionality of the SQL Server – the Linked Servers. Almost everybody knows that the Linked Servers are evil…