THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Apply   (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
Privacy Statement