Performance Surprises and Assumptions : STRING_SPLIT()

SQL Server 2016 RC0 introduces a new native string splitting function, STRING_SPLIT; I compare its performance to existing methods.