|
Free ebooks
 Free database ebooks SQL Inside Microsoft SQL Server 2005: Query Tuning and Optimization
|
|
Chapter 2 - Tracing and Profiling by Adam Machanic (SQL Server MVP. Leader of the New England SQL Server User Group in Boston, and all around smart guy.) Even if you use Profiler daily, you'll pick up some useful info in this thorough converge of SQL Server Engine Trace and the Profiler UI. Chapter 3 - Query Execution by Craig Freedman (Microsoft SQL Server Query Execution Team.) This chapter has more beef than a 16 oz filet in Kansas City. Chapter 4 - Troubleshooting Query Performance by Kalen Delaney and Craig Freedman. This is the practical part two of Craig's amazing chapter 3. Chapter 5 - Plan Caching and Recompilation by Kalen Delaney. This is the topic Kalen presented at the 2007 PASS Summit pre-con and her depth shows in this chapter. Chapter 6 - Concurrency Problems by Ron Talmage (SQL Server MVP, and true gentleman. Ron leads the Pacific Northwest SQL Server Users Group which meets in Building 35, the SQL Server team building on the MIcrosoft Redmond campus.) Download free ebook of SQL: Inside Microsoft SQL Server 2005: Query Tuning and Optimization
|
At first glance, Inside SQL Server Query Tuning and Optimization, appears to be a multiple-author ensemble book with only 1½ chapters written by Kalen, which might be disappointing. However, the reality is that this database dream team is hand-picked by Kalen, and following Kalen's plan the book meets the high standards Kalen is known for. The flow of the information is the right way to understand and then solve query performance issues.