Greg Low might have violated Betteridge’s Law of Headlines:
Using T-SQL it’s quite easy to build a table-valued function that can step through a string, character-by-character, and (based on a delimiter) output the delimited strings. The problem is that the performance of these functions is appalling.
When XML support appeared in SQL Server 2005, there were many attempts to create more efficient string-splitting functions. For many strings, these work quite well, but do have a few oddities that you need to cope with. Plus, most have limitations on the strings that you can split.
Ultimately, what was really needed was an efficient and native built-in function.
Greg points out two mechanisms and contrasts them.