Database Hardware and Infrastructure Trends Glenn Berry (@GlennAlanBerry) provides the SQL Server DBA some insight into the ever-changing world of hardware and infrastructure. Glenn Berry ◆ April 26, 2016 4
STRING_SPLIT() in SQL Server 2016 : Follow-Up #2 With additional tests comparing splitting techniques to TVPs, Aaron Bertrand (@AaronBertrand) rounds out his series on STRING_SPLIT() in SQL Server 2016. Aaron Bertrand ◆ April 22, 2016 15
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. Aaron Bertrand ◆ April 19, 2016 2
Performance Surprises and Assumptions : DATEADD Aaron Bertrand (@AaronBertrand) explores yet another scenario where a date/time function seems to cause the optimizer to behave unexpectedly. Aaron Bertrand ◆ April 11, 2016 12
Knee-Jerk Performance Tuning : Incorrect Use of Temporary Tables Paul Randal (@PaulRandal) continues his knee-jerk performance tuning series, focusing on ways to optimize performance when using temporary tables. Paul Randal ◆ April 6, 2016 17