Finding problematic NOLOCK patterns – Part 1
I start a new series on identifying and removing problematic NOLOCK hints from update and delete statements.
Monthly Archive: July 2021
Minimizing PAGELATCH_EX waits in SQL Server 2019
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.
T-SQL Tuesday #140 : What have you been up to with containers?
For T-SQL Tuesday #140, Anthony Nocentino asks us what we have been up to with containers.
SQL Server 2017 Cumulative Update #25
SQL Server 2017 Cumulative Update #25 is available, with 19 enhancements. The build number is 14.0.3401.7.
Deprecated features to take out of your toolbox – Part 3
I explain why you should eliminate the data types text, ntext, and image from your environment.