Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [batch-mode]

SQL Server batch-mode execution processes plan operator data in 64KB chunks rather than a row at a time.

Filter by
Sorted by
Tagged with
24 votes
1 answer
5k views

What exactly can SQL Server 2014 execute in batch mode?

When a columnstore index is being used in a query SQL Server is able to use batch mode. Documentation is thin on what can run in batch mode and what can't. Please look at the following (motivating) ...
usr's user avatar
  • 7,340