Yearly Archive: 2021

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…

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.

Performance of sys.partitions

After a question on #sqlhelp, I dug into what could be making sys.partitions slow, and how they might get the required information in a more efficient way.