Book Review - oldie but a goodie - Inside SQL 2005 Query Tuning and Optimization

re: Book Review - oldie but a goodie - Inside SQL 2005 Query Tuning and Optimization

Kalen Delaney — Fri, 19 Feb 2010 16:09:12 GMT

Thanks, Rob!

I'd like to point out Chapter 3 on reading execution plans. It was written by one of Microsoft Engineers on the query processing team (Craig Freedman) and it is amazing! I have read that chapter over 4 times and _I_ still learn new things from it. I don't there is anything else publicly available that goes into so much depth on what each operator in a plan means, and how to interpret the overall plan. And 99% of it is completely relevant for 2008. Only 4 of the plans are different in the newer version. Because of page count limitations, we were not able to include this chapter in the 2008 book, so you can think of it as a collectors' item!

~Kalen

re: Book Review - oldie but a goodie - Inside SQL 2005 Query Tuning and Optimization

Rob Farley — Fri, 19 Feb 2010 23:18:08 GMT

It's a shame that that chapter won't appear in the next version, it is an excellent one. Even more reason for people to pick up this version still!

Q&A about my SQLBits precon

Rob Farley — Tue, 31 Aug 2010 12:42:06 GMT

I received an email from someone who’s trying to decide whether or not to register for my precon at SQLBits