Description

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.

Key Features

* Identifies and discusses the most common issues database administrators (DBAs) face day-to-day *Provides DBAs with solutions actually used by the authors in enterprise environments *Explores new features which add more control but reduce performance

Readership

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

Table of Contents

Introduction and Acknowledgements Chapter 1. Performance and SQL Server 2005 Chapter 2. Logical database design for performance Chapter 3. Physical database design Chapter 4. SQL Server storage structures Chapter 5. Indexing Chapter 6. Basic query tuning Chapter 7. What is query optimization? Chapter 8. Investigating and influencing the optimizer Chapter 9. SQL Server 2005 and Windows 2003 Chapter 10. Transactions and locking Chapter 11. Performance and architectural choices Chapter 12. Monitoring performance Appendices Appendix A – Syntax Conventions Appendix B – Database Scripts Appendix C - Performance Strategies and Tuning Checklist

Details

No. of pages:
520
Language:
English
Copyright:
© 2007
Published:
Imprint:
Digital Press
Print ISBN:
9781555583194
Electronic ISBN:
9780080554082