I dig a little deeper into Unicode compression.

A quick first look at Unicode compression, introduced in SQL Server 2008 R2.

Beyond just splitting a comma-separated list of integers, I explain custom delimiters, preventing duplicates, and maintaining order.

Back in the old days, I talked about how I used a numbers table to split comma-separated lists of integers.