Columnstore Indexes – part 135 (“JSON type and JSON Index with Columnstore Indexes”) Continuation from the previous 134 parts, the whole series can be found at Not since SQL Server 2008 that Microsoft has added a new base data type to SQL Server, but in SQL Server 2025 they have ad…

[blog] Columnstore Indexes – part 135 (“JSON type and JSON Index with Columnstore Indexes”):
www.nikoport.com/2026/01/02/c...
#json #jsonindex #columnstore #batch #sqlserver2025

Columnstore Indexes – part 134 (“Vectors and Columnstore Indexes”) Continuation from the previous 133 parts, the whole series can be found at In this post we are going to test one of the more promising technologies in SQL Server-based offerings – Vector data…

Columnstore Indexes – part 134 (“Vectors and Columnstore Indexes”):
www.nikoport.com/2025/12/25/c...
#columnstore #batch #vector #sqlserver2025

Columnstore Indexes – part 132 (“What’s missing in Columnstore indexes in the year 2026”) Continuation from the previous 131 parts, the whole series can be found at After spending some time thinking about the best way to come back to writing about Columnstore Indexes, after 5 and half y…

[blog] Columnstore Indexes – part 132 ("What's missing in Columnstore indexes in the year 2026"):
www.nikoport.com/2025/12/03/c...
#sqlserver #columnstore #azuresql #wishlist

When you create an ordered Non-Clustered Columnstore Index in SQL Server 2025, you need to do it single-threaded (MAXDOP = 1) to get a perfectly working Segment Elimination. The same also applies to Ordered Clustered Columnstore Indexes... #sqlserver #columnstore

I just watched an internal #MariaDB roadmap presentation by Adam Luciano (VP, Product Management), and wow! Tons of new features coming to MariaDB Server, #MaxScale, #ColumnStore, #Galera, programming language connectors, vector search, #AI integrations and tools, and more!

Vertipaq optimization and its impact on columnstore compr... Vertipaq optimization is a critical component of the colu...

Reading: Vertipaq optimization and its impact on #columnstore #compression - https://bit.ly/3qNgjDO #AzureData #AzureSQL #SQLServer