How am I doing?

Using a CTE as a Tally Table

Sometimes you need to output blank lines
- in effect displaying Records for Missing Data. This article explains how to use a CTE to do this

Table Valued Function to return a range of prime numbers

A fast table valued function to generate a list of prime numbers within the range specified by the parameters.

The Christmas CROSS APPLY

Work time calculation

One way to calculate how many minutes a person has worked considering holidays and shifts, being given starting and ending date / time

Nasty Fast N-Grams (Part 1): Character-Level Unigrams

An article about tally tables, N-Grams and the fastest character-level N-Grams function available today for SQL Server.

DigitsOnlyEE and AlphaNumericOnly

A nasty fast way to remove non-numeric and non-alphanumeric characters from a string

New T-SQL Fixed Width "Splitter"

A brand new tally table based, fixed width "splitter" that can be used for much more than just string splitting

Translate function for SQL Server

Relational database management systems such as Oracle, Postgres, DB2 and Teradata, as well as other programming languages such as Python, Hive, XSLT and SAS have a Translate function. Now we have one for SQL Server.

GetNumsAB

A brand new, high-performing, "GetNumbers" or "fnTallyTable" function that can be used for defeating RBAR.