Batch Mode

Columnstore Indexes – part 86 (“New Trace Flags in SQL Server 2016”)

Columnstore Indexes – part 86 (“New Trace Flags in SQL Server 2016”)

Continuation from the previous 85 parts, the whole series can be found at https://www.nikoport.com/columnstore/ With the release of SQL Server 2016, a great number of new functionalities with specific internal structures and own behaviours were created (Columnstore Indexes – part…

Columnstore Indexes – part 85 (“Important Batch Mode Changes in SQL Server 2016”)

Columnstore Indexes – part 85 (“Important Batch Mode Changes in SQL Server 2016”)

Continuation from the previous 84 parts, the whole series can be found at https://www.nikoport.com/columnstore/ I wanted to write a blog post on some of the changes that were implemented in SQL Server 2016, that might affect workloads migrated from SQL…

Columnstore Indexes – part 82 (“Extended Events in SQL Server 2016”)

Columnstore Indexes – part 82 (“Extended Events in SQL Server 2016”)

Continuation from the previous 81 parts, the whole series can be found at https://www.nikoport.com/columnstore/. Previously, I have blogged about about the Extended Events in SQL Server 2014 3 times: Columnstore Indexes – part 44 (“Monitoring with Extended Events”) served as…