MS SQL Server String Join Performance
You are looking at an older version of the documentation. The latest version is found here.
For MS SQL Server string join and sorting performance, please refer to this section which applies not only to MS SQL as analytical storage but also to any MS SQL data source: MS SQL Server as Analytical Storage.