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…
Continuation from the previous 110 parts, the whole series can be found at https://www.nikoport.com/columnstore/. The topic of the Segment Elimination (aka Row Group Elimination) is something that I keep on blogging on through all the years, but given that Joe…
Continuation from the previous 109 parts, the whole series can be found at https://www.nikoport.com/columnstore/. In this blog post I wanted to share my thoughts & my script that I am using for picking the best column for achieving the best…