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.