Reduce CPU of Large Analytic Queries Without Changing Code - Simple Talk

added by DotNetKicks
3/25/2020 4:09:37 PM

353 Views

When Microsoft came out with columnstore in SQL Server 2012, they introduced a new way to process data called . Batch mode processes a group of rows together as a batch, instead of processing the data row by row. By processing data in batches, SQL Server uses less CPU than row by row processing.


0 comments