April 2016
STRING_SPLIT: Follow-up #2

With additional tests comparing splitting techniques to TVPs, I round out my series on STRING_SPLIT() in SQL Server 2016.

STRING_SPLIT: Follow-up #1

I follow up on a recent post about the performance of STRING_SPLIT() with a few additional reader-motivated tests.

Performance surprises: DATEADD

I explore yet another scenario where a date/time function seems to cause the optimizer to behave unexpectedly.