SentryOne Team Blog (blogs.sentryone.com)

Tag: grouped concatenation

SQL Server v.Next : STRING_AGG Performance, Part 2

SQL Server v.Next : STRING_AGG Performance, Part 2

Aaron Bertrand (@AaronBertrand) starts digging deeper into the performance of string concatenation methods STRING_AGG and FOR XML PATH.

SQL Server v.Next : STRING_AGG() performance

SQL Server v.Next : STRING_AGG() performance

Aaron Bertrand takes an initial look at the performance of a new function, STRING_AGG, in SQL Server v.Next CTP 1.1.

Four Practical Use Cases for Grouped Concatenation

Following up on Grouped Concatenation in SQL Server and Grouped Concatenation : Ordering and Removing Duplicates, Aaron Bertrand (@AaronBertrand) provides four real-world examples where grouped concatenation allows you to avoid the monotony of cursors and while loops.