I tried the same comparisons with a real-world example, a data table with over 200,000 rows. In the first iteration the cursor method took 15 seconds, while I killed...

I don't know if anyone else has already pointed this out, but I was able to add a root node by specifying

FOR XML EXPLICITY, ROOT('CustomersByRegion')

The code below generated fully formed...