Page Free Space

This article was originally published on 𝕏. Background Since SQL Server indexed views don’t allow MIN or MAX aggregates, I recently fo...

A bug with Halloween Protection and the OUTPUT Clause Background The OUTPUT clause can be used to return results fro...

Halloween Protection – The Complete Series I have written a four-part series on the Halloween Problem . Some of you wi...

Optimizing T-SQL queries that change data Most tuning efforts for data-changing operations concentrate on the SELECT s...

Deletes that Split Pages and Forwarded Ghosts Can DELETE operations cause pages to split? Yes. It sounds counter-int...