freecomputerbooks.pickatutorial.com Computer Tutorials and Books
Tutorials: C / C++ | C#.NET | PHP MySQL | Java | Java Script | jQuery | HTML | xHTML | HTML5 | VB Script | CSS

Books: C/C++ | C# | Android | Mathematics | Database | Cloud | Graphics | Networking | Oracle | Hardware | AI
Categories Download eBook: SQL Server Statistics Bookmark and Share

Book Catagory:SQL Server
Title SQL Server Statistics
Author(s) Holger Schmeling
Publisher: Red Gate books (November 15, 2010)
Language: English
Book Description

A Distribution Statistics object is a sampled map of the distribution of data in a table. Such statistics help the Query Optimizer of SQL Server's Database Engine to translate the 'logical' SQL Query into the best strategy for doing all the physical operations of joining, sorting, and selecting the data. Most of the time, this work happens effectively without the database administrator having to be aware of what is going on, but occasionally, if the statistics no longer reflect what is actually in the table, then queries can suddenly run grindingly slow. At this point, the DBA must intervene to correct the problem.

Holger divides his work into two parts. In the first part, he explains what "statistics" are, why they are there, how they are created, updated and removed. He shows how to inspect them and to maintain them. In the second part, he lists all the problems that are related to these statistics objects, and how to solve them.
Download eBook
|
|
|
SQL Server Statistics

More SQL Server eBooks:
BI Solutions Using SSAS Tabular Model Succinctly
Introducing Microsoft SQL Server 2014: Technical Overview
SQL Server Analysis Services Succinctly
Fundamentals of SQL Server 2012 Replication
SQL Server Concurrency: Locking, Blocking and Row Versioning
SQL Server Execution Plans, Second Edition
The Art of SQL Server FILESTREAM
Performance Tuning with SQL Server Dynamic Management Views
SQL Server Backup and Restore
Inside the SQL Server Query Optimizer
Introducing Microsoft SQL Server 2012
Introducing Microsoft SQL Server 2008 R2
The Red Gate Guide to SQL Server Team-based Development
Defensive Database Programming with SQL Server
Brad's Sure Guide to SQL Server Maintenance Plans






Home - Advertise - Contact - Disclaimer - About Us
© Since 2006 pickatutorial.com -- All Rights Reserved.