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…
Columnstore Indexes – part 115 (“Bulk Load API and Pressure”)
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…
Columnstore Indexes – part 114 (“Machine Learning Services”)
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…
Columnstore Indexes – part 113 (“Row Groups Merging Limitations”)
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 –…
Columnstore Indexes – part 112 (“Linked Servers”)
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…