SentryOne Team Blog (blogs.sentryone.com)

Tag : STRING_SPLIT

STRING_SPLIT() in SQL Server 2016 : Follow-Up #2

Aaron Bertrand (@AaronBertrand) shows that, at least for a large number of integer parameters, it is actually OPENJSON() that beats both the new STRING_SPLIT() function and TVPs, and leaves traditional splitting methods in the dust.

STRING_SPLIT() in SQL Server 2016 : Follow-Up #1

Aaron Bertrand (@AaronBertrand) follows up on a recent post about the performance of STRING_SPLIT() with a few additional reader-motivated tests.

Performance Surprises and Assumptions : STRING_SPLIT

SQL Server 2016 RC0 introduces a new native string splitting function, STRING_SPLIT. Aaron Bertrand (@AaronBertrand) compares its performance to existing methods.