I just received my copies of the book. “SQL Server 2008 Query Performance Tuning Distilled” is an honest to gosh, in print, available on Amazon
and Barnes & Noble BOOK!
Sorry, just need a little time for a victory dance on the table. Huzzah!
I learned a lot from Dissecting SQL Server Execution Plans, so I’m looking forward to reading your new book. Amazon.ca has a delivery estimate of March 27 – April 1, so I guess I’ll still have to wait for a few weeks. The suspense is killing me! Okay, maybe not, but I’m still looking forward to it.
I’m very happy to hear that the Execution Plans book was helpful. Of the two, I think it’s the more unique resource, but I hope this one helps as well.
I don’t know what’s up with the shipping from Amazon. I’ve seen it say March 29th, 23rd and 16th. Last I looked it was saying 1-2 months. I suspect it’s in the pipeline there, but fully distributed yet.
Isn’t it such a nice feeling to get into your hands a real live paper book written by yourself; something you can give to devoted aunts, leave casually on the coffee table, thumb through and think to yourself ‘blimey I did that!’. Oh yes. Many congratulations on both books. Heaven knows, it represents a lot of hard work.
My name is Tony Garofalo, SQL Server DBA since SQL Server 7.0. I first purchased this book when Sajal wrote the 2nd Edition for SQL 2000. I went through that book like it was written especifically for me. I even sent him an email some time ago asking that it be re-released for 2005 or 2008, I don’t remember which or if it even reached him.
However, I am pleased to see this newly released version of the book and I’m reading every page with enthusiasm. There is one topic I was genuinely hoping to see covereed and it is not discussed, assemblies. CLR stored procedures are very much the responsibility of the DBA since they reside in our databases. What I was hoping to read about and see was a discussion on how to decide which was the better stored procedure to implement, the CLR version or the native SQL procedure with the statistics and graphics to support the decision. CLR stored procedures and other assembly objects are very much a part of the application layer, as illustrated on pg. 9 “Where to Focus Efforts”.
The Apress release, Pro SQL Server 2005 Assemblies has been a great help to me in understanding the creation and use of this fairly recent set of objects which we DBA’s need a handle on. Your contribution to the performance metrics regarding their use could be a greatly valued contribution to our set of skills.
Regards and Thanks Again for the Updated Book,
I do agree that CLR is something that affects DBA’s when it is used. Fortunately or unfortunately, very few applications are using it. I don’t have any taking advantage of it where I work. Since it’s such an under-utilized resource, it’s hard to include it in a generalists book. I’m not that acquainted with it myself. I’m glad there are specialists books out there that support it.
I do hope Query Tuning Distilled is still useful to you.