Tag: SQL Server 2016 batch mode operators

When ‘columnstore’ indexes were introduced in SQL Server 2012, they were solidly in the data warehouse and analytic camp. While providing impressive performance improvement for many queries of types commonly used in analysis, tables with ‘columnstore’ indexes were not able to be updated, rendering them useless for transaction processing applications. In SQL 2014 and again […]