Hello! Thank you for interesting article! 🙂

GROUPING SETS were new for me. I've tried an example using GROUPING SETS and UNION ALL. I've just noticed that the ordering of returning rows is different.

Also the number of logical reads is less when using GROUPING SETS.