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
There are many articles on these topics available on web (google it, you will get lot of stuff there), I found these articles helpful and easy to understand.
SQL Server Transaction Isolation Models
http://databases.about.com/od/sqlserver/a/isolationmodels.htm
The ACID Model
http://databases.about.com/od/specificproducts/a/acid.htm
Partitioning a SQL Server Database Table
http://databases.about.com/od/sqlserver/a/partitioning.htm
Filegroups in SQL Server 2005
http://www.mssqltips.com/tip.asp?tip=1112
Nice tool for SQL User.
Intellisense for SQL Query Analyzer, You can get it from here.
http://www.red-gate.com/products/SQL_Prompt/index.htm
Good One.
