Microsoft SQL Server 2005 Performance Optimization and Tuning Handbook

Ken England is President and Founder of Database Technologies, a database consulting, product evaluation and training firm. A Microsoft Certified Systems Engineer and a Microsoft Certified Trainer, Ken England is widely regarded as an authority on SQL Server and other leading database products. He is also the author of the SQL Server 6.5 Performance Optimization and Tuning Handbook. Gavin Powell, BSc. Comp.Sci., OCP (Oracle8i Certified Professional) has fifteen years of computer industry experience. Diverse experience in database administration and database development in both relational and object databases. Applications development experience is procedural and object-oriented. He also has some systems administration experience. His extensive consulting experience includes software vendors, internet .COM’s (some unfortunately have met with their demise), accounting, banking, financial services, the travel industry, construction, retail, mining, shipping, education and general advisory capacity. Gavin Powell has worked with many software products, tools and programming languages. These tools include items in the list shown below. He has authored two successful books Oracle …High performance Tuning and the just released Oracle SQL

• Introduction and AcknowledgementsChapter 1. Performance and SQL Server 2005Chapter 2. Logical database design for performanceChapter 3. Physical database designChapter 4. SQL Server storage structuresChapter 5. IndexingChapter 6. Basic query tuningChapter 7. What is query optimization?Chapter 8. Investigating and influencing the optimizerChapter 9. SQL Server 2005 and Windows 2003Chapter 10. Transactions and lockingChapter 11. Performance and architectural choicesChapter 12. Monitoring performanceAppendicesAppendix A – Syntax ConventionsAppendix B – Database ScriptsAppendix C - Performance Strategies and Tuning Checklist