Book: SQL Server Query Performance Tuning Distilled
Last two months I have been reading SQL Server Query Performance Tuning Distilled (Second Edition) by Sajal Dam.
This book covers SQL Server 2000 but I believe it is still valid for 99.9% for SQL Server 2005. It gave me lots of insight in query tuning and Dam shows lots of useful scripts that monitor your databases, like checking for and defragging fragmented tables and indexes.
From a developers perspective I believe this book is extremely valuable. It helped me out already last month with some bad performing queries and I know it will continue to help me in the future. This book is a must have for every data-driven application developer!

- Books, Databases - one comment / No trackbacks - § ¶
Good article.
I've created a factsheet for SQL server developers that fits on one A4 (printed on both sides). You can laminate it and keep it on your desk.
http://www.dotnet4all.com/snippets/2008/..
Xander (URL) - 05 04 08 - 21:46