In this post I want to take a look at how batch mode and column store indexes perform in two scenarios: Sequential scans Fact table to dimension table join Sequential scans demonstrate some interesting nuances depending […]

In my last post I covered material which to a large degree was SQL Server agnostic, in this posting I will elaborate on why and how it relates to SQL Server. Firstly, what difference does batch […]