 |
|
| MICROSOFT SQL SERVER 2005 PERFORMANCE OPTIMIZATION AND TUNING HANDBOOK
| |
| | |
|
|
 To order this title, and for more information, click here
By
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.
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.
Audience
Microsoft SQL Database Administrators, Developers, and Systems Managers. Students, end users.
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
| Bibliographic details |
Paperback, 520 pages, publication date: APR-2007
ISBN-13: 978-1-55558-319-4
ISBN-10: 1-55558-319-9
Imprint: DIGITAL PRESS
|
| Price and Ordering |
Price:
EUR 44.99
GBP 34.99
USD 59.95
|  |
Books and book related electronic products are priced in US dollars (USD), euro (EUR), and Great Britain Pounds (GBP). USD prices apply to the Americas and Asia Pacific. EUR prices apply in Europe and the Middle East. GBP prices apply to the UK and all other countries.
|
See also information about conditions of sale & ordering procedures, and links to our regional sales offices.
|
077/763
Last update: 27 Sep 2008
|
|
| |
| | |
|
|
| |
