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