Microsoft SQL Server 2005 Performance Optimization and Tuning Handbook


  • Ken England, Microsoft Certified Systems Engineer and a Microsoft Certified Trainer, President and Founder of Database Technologies, a database consultancy, product evaluation and training firm.
  • Gavin Powell, Microsoft and Database consultant; Author of seven database books.

Database professionals will find that this new edition aids in mastering the latest version of Microsoft’s SQL Server. Developers and database administrators (DBAs) use SQL on a daily basis in application development and the subsequent problem solving and fine tuning. Answers to SQL issues can be quickly located helping the DBA or developer optimize and tune a database to maximum efficiency.Basic questions are easily located on the topics of filtering, sorting, operators, conditionals, pseudo columns, single row functions, joins, grouping functions, sub queries, composite queries, hierarchies, flashback queries, parallel queries, expressions and regular expressions. Assistance on DML, data types (including collections), XML, DDL for basic database objects such as tales, views and indexes, partitioning, and security is also considered.
View full description


Microsoft SQL Database Administrators, Developers, and Systems Managers. Students, end users.


Book information

  • Published: April 2007
  • Imprint: DIGITAL PRESS
  • ISBN: 978-1-55558-319-4

Table of Contents

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 performanceAppendices Appendix A – Syntax Conventions Appendix B – Database Scripts Appendix C - Performance Strategies and Tuning Checklist