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 » Internals » Statistics   (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
  • Geek City: Accessing Distribution Statistics

    Distribution statistics are one of the most important sources of information that the Query Optimizer uses to determine a good query plan. In this post, I’m not going to tell you everything about distribution statistics. I’m just going to show you a few tricks for getting access to the statistics. If you want a deeper understanding of what the ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on January 18, 2013
Privacy Statement