Grouping Sets in SQL Server 2008
http://blogs.msdn.com/b/craigfr/archive/2007/10/11/grouping-sets-in-sql-server-2008.aspx
Aggregation WITH ROLLUP
http://blogs.msdn.com/b/craigfr/archive/2007/09/21/aggregation-with-rollup.aspx
Aggregation WITH CUBE
http://blogs.msdn.com/b/craigfr/archive/2007/09/27/aggregation-with-cube.aspx
