UNION ALL Optimization Paul White (@SQL_Kiwi) digs into row goals as he explains some interesting and inconsistent behavior with UNION ALL queries in SQL Server. Paul White ◆ May 10, 2017 0
Comparing string splitting / concatenation methods Aaron Bertrand (@AaronBertrand) compares the performance of different UDFs and raw queries used for splitting and reassembling a delimited string. Aaron Bertrand ◆ January 22, 2016 14
Grouped Concatenation : Ordering and Removing Duplicates Aaron Bertrand (@AaronBertrand) of SQL Sentry takes a closer look at some additional requirements for typical grouped concatenation queries in SQL Server. Aaron Bertrand ◆ August 20, 2014 10
Grouped Concatenation in SQL Server SQL Sentry's Aaron Bertrand (@AaronBertrand) shows the safest and most efficient ways to perform grouped concatenation in SQL Server. Aaron Bertrand ◆ August 6, 2014 22