Did you know? SQL Server 2008 includes GROUPING SETS

SQL Server 2008 includes GROUPING SETS:

Grouping Sets is an extension to the GROUP BY clause that lets users define multiple groupings in the same query. Grouping Sets produces a single result set that is equivalent to a UNION ALL of differently grouped rows, making aggregation querying and reporting easier and faster.

Read more about this in the SQL Server 2008 BOL ‘GROUPING SETS’.

Check out a screencast about the new GROUPING SETS feature in SQL Server 2008 here.

Did you know? SQL Server 2008 includes GROUPING SETS from Dan English on Vimeo.