Cursor pagination keyed on a monotonic id, and a new sort option that broke the guarantee it relied on. Any cursor needs a total order and a non-unique…
A query that improved by a factor of twenty after a major version upgrade, examined rather than accepted. Understanding why something got faster is worth the ten minutes…
A query with a hand-written optimiser hint from 2019, re-examined after an upgrade, where the hint was now choosing the worse plan. A hint is a decision frozen…
A query creating an internal temporary table that exceeded the in-memory limit on every execution, silently. The ratio of disk to memory temporary tables is the diagnostic and…
An include parameter added for one consumer, and eleven values later it is a query language with no grammar. An include parameter is a small query language and…