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…
I am glad to share that the 1.5.0 release of the CISL (Columnstore Indexes Scripts Library) is finally released. The biggest news is the initial support for the Azure SQL DataWarehouse, with the 5 scripts (Alignment, Dictionaries, Fragmentation, Row Groups…
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…
Continuation from the previous 108 parts, the whole series can be found at https://www.nikoport.com/columnstore/. Do you remember one of the major problems in SQL Server 2014 using Columnstore Indexes ? It was the lack of the support for the Batch…