I show how to denormalize data using FOR XML PATH and STRING_AGG, and explain which one is faster.

Privacy laws are going to make us all much more careful about how we handle data archival and purge processes.