SQL Server

Columnstore Indexes – part 134 (“Vectors and Columnstore Indexes”)

Columnstore Indexes – part 134 (“Vectors and Columnstore Indexes”)

Continuation from the previous 133 parts, the whole series can be found at https://www.nikoport.com/columnstore/. In this post we are going to test one of the more promising technologies in SQL Server-based offerings – Vector data types and its relationship with…

Columnstore Indexes – part 133 (“Data Replication features and Columnstore”)

Columnstore Indexes – part 133 (“Data Replication features and Columnstore”)

Continuation from the previous 132 parts, the whole series can be found at https://www.nikoport.com/columnstore/. In the Columnstore Indexes space, there is a long-standing “tradition” in Microsoft to ignore the needs of the customers for data replication. It has started with…