SQL Server 2005 Practical Troubleshooting: The Database Engine
Author: Ken Henderson
Never-Before-Published Insiders’ Information for Troubleshooting SQL Server 2005.
This is the definitive guide to troubleshooting the Microsoft SQL Server 2005 database engine, direct from the people who know it most intimately: the people who wrote it, designed it, and support it. SQL Server expert Ken Henderson, author of the best-selling Guru’s Guides to SQL Server, has assembled a “dream team” of SQL Server developers and support engineers to provide in-depth troubleshooting and diagnostic information that has never been documented before: information that would be impossible to get without access to Microsoft’s own source code.
From caching to clustering, query processing to Service Broker, this book will help you address even the toughest problems with database engine operations. Each chapter begins with a brief architectural overview of a key SQL Server component, then drills down into the most common problems users encounter, offering specific guidance on investigating and resolving them. You’ll find comprehensive, in-depth chapters on
• Waiting and blocking
• Data corruption and recovery
• Memory
• Procedure cache issues
• Query processing
• Server crashes and other critical failures
• Service Broker
• SQLOS and scheduling
• tempdb
• Clustering
This is the indispensable resource for everyone who must keep SQL Server running smoothly: DBAs, database application developers, API programmers, and Webdevelopers alike.
CD-ROM Contains the revolutionary SQL Server performance diagnostic tool, SQL NexusTM; TraceBusterTM, one of the world’s fastest SQL Server Profiler trace reader/analyzers; DataDemonTM, one of the fastest, most versatile file import utilities available; and sample code and scripts from the book.
Contents
About the Authors ix
Preface xii
Acknowledgments xiv
1 Waiting and Blocking Issues 1
2 Data Corruption and Recovery Issues 47
3 Memory Issues 137
4 Procedure Cache Issues 183
5 Query Processor Issues 225
6 Server Crashes and Other Critical Failures 273
7 Service Broker Issues 331
8 SQLOS and Scheduling Issues 369
9 Tempdb Issues 411
10 Clustering Issues 425
The Aging Champion 441
Index 445
Table of Contents:
PrefaceChapter 1 Waiting and Blocking Issues
Chapter 2 Data Corruption and Recovery Issues
Chapter 3 Memory Issues
Chapter 4 Procedure Cache Issues
Chapter 5 Query Processor Issues
Chapter 6 Server Crashes and Other Critical Failures
Chapter 7 Service Broker Issues
Chapter 8 SQLOS and Scheduling Issues
Chapter 9 Tempdb Issues
Chapter 10 Clustering Issues
Index
See also: The Smart Womans Guide to Plastic Surgery or Pretty
Quickbooks 2005 for Dummies
Author: Stephen L Nelson CPA MBA MS
Here's what you need to become your own accountant! If you love running a business, but despise keeping the books, this is the book for you! Revised throughout to cover the latest updates and enhancements made to QuickBooks, Quickbooks 2005 For Dummies covers the basics, walks you through the software installation, and guides you step-by-step through various accounting functions, including:
• Creating invoices and credit memos
• Tracking accounts receivable and payable
• Paying bills
• Monitoring and managing inventory
• Balancing the books
• Printing checks or paying with plastic
• Doing your banking online
• Processing payroll
Written by Stephen Nelson, the author of more than 100 books, including all editions of QuickBooks For Dummies, Quickbooks 2005 For Dummies takes you beyond everyday accounting tasks and helps you use information to boost your productivity and profits by:
• Generating and sharing financial reports
• Building budgets
• Efficiently estimating, billing, and tracking jobs
To expedite your bookwork and grow your business by the numbers, you don’t have to hire expensive consultants or become a CPA; just become a QBE—a QuickBooks Expert. With this book and your QuickBooks software, everything you need to know is at your fingertips!
0 comments:
Post a Comment