THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Undocumented » Aggregates   (RSS)
  • SQL Server 2019 Aggregate Splitting

    The SQL Server 2019 query optimizer has a new trick available to improve the performance of large aggregations. The new exploration abilities are encoded in two new closely-related optimizer rules: GbAggSplitToRanges SelOnGbAggSplitToRanges The extended event query_optimizer_batch_mode_agg_split is provided to track when this new ...
    Posted to Page Free Space (Weblog) by Paul White on August 3, 2020
  • Pulling Group By Above a Join

    One of the transformations available to the SQL Server query optimizer is pulling a logical Group By (and any associated aggregates) above a Join. Visually, this means transforming a tree of logical operations from: …to this: The above diagrams are logical representations. They need to be implemented as physical operators to appear in an ...
    Posted to Page Free Space (Weblog) by Paul White on August 3, 2020
Privacy Statement