Category: SQL Server

Just Enable Indirect Checkpoints on All Databases, Please

In this tip I show how indirect checkpoints can help improve performance and stability of more than just checkpoint operations themselves, and stifle some (but not all) problems. I conclude that you should proactively change this setting everywhere.

Ordered string splitting in SQL Server with OPENJSON

Every time I write a post about splitting strings, I promise myself it's the last one. I need to stop making that promise. In this tip, I show how I compared my previous favorite ordered splitting function to a different technique using OPENJSON().

A handy search procedure

Updated this stored procedure I wrote a decade ago to search for a string in procedure bodies, object names, job steps, and more…