I found these good articles on Grouping Sets and Spatial Datatypes
Grouping Sets, By Cube, By Rollup
http://blogs.msdn.com/craigfr/archive/2007/10/11/grouping-sets-in-sql-server-2008.aspx
Spatial Data types (Series of articles)
http://jasonfollas.com/blog/archive/2008/03/14/sql-server-2008-spatial-data-part-1.aspx

