Undocumented Wait Types Added in SQL Server 2022
SQL Server 2022 added 353 wait types. I grouped them by family and found 339 without a public description.
Undocumented DMVs Added in SQL Server 2022
A closer look at undocumented SQL Server 2022 DMVs and functions for request phases, XTP hash indexes, CDC, governance and retired internals.
The 11 Configuration Options Added in SQL Server 2022, and Their Documentation
I checked the 11 SQL Server 2022 configuration options added after SQL Server 2019 against sys.configurations and Microsoft Learn.
I Could Not Find Documentation for Most of What SQL Server 2022 Added
I diffed the SQL Server 2019 and 2022 system catalogs over the DAC and checked 558 new objects against Microsoft Learn. I found no documentation for 477.
Forwarded Records: the Back-Pointer and the Trip Home
Note: a self-contained MCVE reproducing every result in this post is included at the end - see "The MCVE: run it yourself". Hugo Kornelis recently challenged a sentence in my post on how SQL Server…
What ROW and PAGE Compression Do to the Record
Data compression is one of the few storage features you can turn on with a single clause and measure the same afternoon. It changes the physical format of the record on the page, not the…