Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Troubleshooting SQL Server - A Guide for the Accidental DBA

Buy
I've spent much of the last six years of my working life trying to help people solve SQL Server-related performance problems, either hands-on, at client sites in my capacity as a consultant, or on various online community forums, answering people's questions.

Over that time I've been exposed to a few weird and wonderful SQL Server issues but, mainly, have seen the same problems, and the same confusions, crop up time and again. It was only a matter of time before I leapt to the foolhardy conclusion that I ought to write a book to explain what the most common problems were, why they occurred, and to offer sensible, practical solutions, aimed squarely at removing the root cause of the issue, rather than simply "papering over the cracks."

It turned out to be a much more daunting task than I imagined, for a number of reasons. Firstly, this is, by its very nature, a fairly broad-ranging book, covering topics stretching from CPU issues, to memory management, to missing indexes, and full transaction logs. Secondly, it is amazing how complex some of the simplest topics become when you try to put them down in text. Thirdly, technology changes rapidly, and the troubleshooter, and the advice he or she offers, must adapt accordingly. There were several cases in the writing of this book, where either a technology change meant I had to go back and adapt my original advice, or where my own opinion of the content and troubleshooting methodologies had evolved to the point where certain sections had to be completely rewritten.

Despite the occasionally bumpy road, what I hope I've achieved is a book that covers clearly and concisely the most common problems associated with the currently supported versions of SQL Server, namely SQL Server 2005, 2008, and 2008 R2. The first chapter explains my basic approach to performance troubleshooting, and the tools I use. It stresses, in particular, how rare it is that a problem can be diagnosed by looking at just a single data point.
(HTML tags aren't allowed.)

Fundamentals of Animation
Fundamentals of Animation

Discusses the key principles and processes involved in animation; exploring the entirety of the creative process, from finding and researching a concept, through the preparation and techniques used, to the execution of the work. Each stage is presented in an engaging visual style, accompanied by examples and analysis of contemporary student...

Systems Biological Approaches in Infectious Diseases (Progress in Drug Research)
Systems Biological Approaches in Infectious Diseases (Progress in Drug Research)
The much-lamented “innovation gap” often referenced by current authors with respect to drug discovery in the pharmaceutical industry is a sure sign that an era has passed. The reductionist view of disease as the direct consequence of isolated errors of metabolism that could be explained and understood as simple enzyme...
Amorphous Silicon / Crystalline Silicon Heterojunction Solar Cells (SpringerBriefs in Applied Sciences and Technology)
Amorphous Silicon / Crystalline Silicon Heterojunction Solar Cells (SpringerBriefs in Applied Sciences and Technology)

Amorphous Silicon/Crystalline Silicon Solar Cells deals with some typical properties of heterojunction solar cells, such as their history, the properties and the challenges of the cells, some important measurement tools, some simulation programs and a brief survey of the state of the art, aiming to provide an initial framework in this...


First Course on Fuzzy Theory and Applications (Advances in Soft Computing)
First Course on Fuzzy Theory and Applications (Advances in Soft Computing)

This basic textbook gives an easily accessible introduction to fuzzy theory and its applications. It provides basic and concrete concepts of the field in a self-contained, condensed and understandable style. This First Course on Fuzzy Theory and Applications includes numerous examples, descriptive illustrations and figures of the basic concepts,...

Programmable Logic Controllers, Fifth Edition
Programmable Logic Controllers, Fifth Edition

A programmable logic controllers (PLC) is a real-time system optimized for use in severe conditions such as high/low temperatures or an environment with excessive electrical noise. This control technology is designed to have multiple interfaces (I/Os) to connect and control multiple mechatronic devices such as sensors and actuators.
...

Microwave Transistor Amplifiers: Analysis and Design (2nd Edition)
Microwave Transistor Amplifiers: Analysis and Design (2nd Edition)
A unified presentation of the analysis and design of microwave transistor amplifiers (and oscillators) — using scattering parameters techniques.

FEATURES:

  • A clear and straightforward presentation designed to be comprehensive. A self-contained book.
  • Examples based on practical...
©2018 LearnIT (support@pdfchm.net) - Privacy Policy