I start a new series on identifying and removing problematic NOLOCK hints from update and delete statements.
July 2021
In this tip, I show how to evaluate a new index option in SQL Server 2019 aimed at reducing PAGELATCH_EX waits.
For T-SQL Tuesday #140, Anthony Nocentino asks us what we have been up to with containers.
I explain why you should eliminate the data types text, ntext, and image from your environment.