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 » Performance » Execution Plan   (RSS)
  • Closest Match with Sort Rewinds

    In When Do SQL Server Sorts Rewind? I described how most sorts can only rewind when they contain at most one row. The exception is in-memory sorts, which can rewind at most 500 rows and 16KB of data. These are certainly tight restrictions, but we can still make use of them on occasion. To illustrate, I am going reuse a demo Itzik Ben-Gan ...
    Posted to Page Free Space (Weblog) by Paul White on October 18, 2020
  • 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
Privacy Statement