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
This post is part of the series. The contents page lists every part in order. Note: a self-contained MCVE reproducing every result in this post is included at the end - see "The MCVE: run…
What ROW and PAGE Compression Do to the Record
This post is part of the series. The contents page lists every part in order. Data compression is one of the few storage features you can turn on with a single clause and measure the…
A Tour of SQL Server Page Types: Data, GAM, SGAM, PFS, IAM
Most of this storage series has been spent inside data pages, pulling rows apart byte by byte. But a data file is not only data pages. Scattered through it, at fixed and predictable spots, are…
Forwarded Records: What an UPDATE Can Do to a Heap
This post is part of the series. The contents page lists every part in order. A heap, a table with no clustered index, has a failure mode that clustered tables do not: an UPDATE that…