SQL Server 2005 Best Practices Analyzer (January 2008)

http://www.microsoft.com/downloads/details.aspx?FamilyId=da0531e4-e94c-4991-82fa-f0e3fbd05e63&displaylang=en
http://davidhayden.com/blog/dave/archive/2008/01/19/SQLServer2005BestPracticesAnalyzerJanuary2008.aspx

Maintain indexes in a SQL Server 2005 database

http://www.exforsys.com/tutorials/sql-server-2005/maintaining-sql-server-indexes.html

SQL Server 2005 XQuery and XML-DML

An Overview of XML Support in SQL Server 2005
http://www.15seconds.com/issue/050803.htm

Improving XML Data Access Performance with SQL Server 2005
http://www.15seconds.com/issue/050811.htm

Improving XML Update Performance with SQL Server 2005
http://www.15seconds.com/issue/050818.htm

Tips for Rebuilding Indexes SQL Server 2005

http://www.sql-server-performance.com/tips/rebuilding_indexes_p1.aspx

Common Table Expressions

http://www.setfocus.com/TechnicalArticles/sql-server-2005-tsql-3.aspx