Book Review: SQL Server 2008 Query Performance Tuning Distilled

Hi all.

I want to share some thoughts about this outstanding book from APress.

Ok, first of all the book is short, concise and very easy to read. This should be a must read for every single developer that get’s involved in SQL Server 2008. It’s quite complete despite it’s short length (600 pages – remember this includes table of contents and all that).

So perhaps the most interesting thing in the book regarding the topics covered is that includes all the aspects to take into account when writing queries like the tools to verify execution plans, analysis of cursors, deadlocks and all the wonderful stuff we run into when dealing with queries.

However, nothing is perfect. One of the problems I found when reading it is that it doesn’t cover subjects like T-SQL Refactoring or techniques to handle integration with other systems like Oracle. But don’t get me wrong, this are rare environments and only happen with big companies with lots of systems. Anyway maybe for a future edition. The other thing is that is not the definitely guide to tuning queries, although is very close.

Get it here at Amazon.com or directly from APress.

Book Details By Grant Fritchey , Sajal Dam ISBN13: 9781430219026 ISBN10: 1430219025 600 pp. Pub Date: 2009-03-16 eBook Price: $38.49