Why I don't like the WHILE (1=1) pattern
In this tip, I discuss one way to help avoid infinite loops in common while loop patterns.
Finding problematic NOLOCK patterns – Part 4
In part 4, I show how to include ad hoc DML queries in the analysis.
Finding problematic NOLOCK patterns – Part 3
In part 3, I tie it together and show how to use relational logic to further eliminate false positives.
T-SQL Tuesday #141 : Work/Life Balance
For this month's T-SQL Tuesday, TJay Belt asks us to talk about how we manage work/life balance.
SQL Server 2019 Cumulative Update #12
SQL Server 2019 Cumulative Update #12 is available, with 40 enhancements (29 public). The build number is 15.0.4153.1.
Finding problematic NOLOCK patterns – Part 2
In part 2, I show how to identify problematic NOLOCK patterns across multiple databases and multiple instances.
Finding problematic NOLOCK patterns – Part 1
I start a new series on identifying and removing problematic NOLOCK hints from update and delete statements.
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.
SQL Server 2019 Adventures on CentOS 7.5
After thinking setting up SQL Server 2019 on CentOS 7.5 was going to be a piece of cake, I explain how my team helped resolve a TLS issue preventing remote connections.
How to USE a Calendar Table – Part 3
For the last part in my series on using a calendar table, and with some help from Itzik Ben-Gan, I describe how you can solve complex scheduling problems.
SQL Server 2019 Cumulative Update #11
SQL Server 2019 Cumulative Update #11 is available, with 62 enhancements. The build number is 15.0.4138.2.
SQL Server 2017 Cumulative Update #24
SQL Server 2017 Cumulative Update #24 is available, with 30 enhancements. The build number is 14.0.3391.2.
How to USE a Calendar Table – Part 2
In this part of my "using a calendar table" series, I talk about filling gaps and identifying gaps and islands.
How to USE a Calendar Table – Part 1
It seems a lifetime ago I wrote about creating a calendar table; now I've started a new series showing how to use the calendar table. In the first installment, I deal with business day problems.
SQL Server 2019 Cumulative Update #10
SQL Server 2019 Cumulative Update #10 is available, with 63 enhancements. The build number is 15.0.4123.1.
Maintaining LastModified Without Triggers
A not exactly innovative post about using Temporal Tables functionality to automatically update a LastModified column.
SQL Server 2016 SP2 Cumulative Update #17
SQL Server 2016 SP2 Cumulative Update #17 is available, with 20 enhancements. The build number is 13.0.5888.11.
Deprecated features to take out of your toolbox – Part 2
I use a real-world example showing why you shouldn't use deprecated functionality like SQL Server Profiler.