Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Articles with tag statistics Rss

Search for any content tagged statistics

<< Newer    Items 21 to 35 of 35   

Questions About SQL Server Distribution Statistics

Fabiano Amorim was asked a couple of questions about SQL Server Distribution Statistics. Having given an answer based on his current knowledge, he then decided to find out for himself whether what he'd said was right, and started an epic journey of exploration into Distribution Statistics and the way that the Query Optimiser uses them.  Read more...
By Additional Articles 2011/07/12 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 1,942 reads

Automatic Statistics Update Slows Down SQL Server 2005

I have a database which has several tables that have very heavy write operations. These table are very large and some are over a hundred gigabytes. I noticed performance of this database is getting slower and after some investigation we suspect that the Auto Update Statistics function is causing a performance degradation.  Read more...
By Additional Articles 2011/02/25 | Source: | Category: maintenance
Rating: (not yet rated)  Rate this |   Briefcase | 4,954 reads

SQL Server Statistics: Problems and Solutions

SQL Server Statistics assist the query optimiser to calculate the best way of running the query. Holger describes every common way that things can go wrong with statistics, and how to put matters right.   Read more...
By Additional Articles 2010/11/11 | Source: SimpleTalk | Category: statistics
Rating: (not yet rated)  Rate this |   Briefcase | 3,488 reads

Introduction to SQL Server Statistics

A free virtual chapter presentation by Andy Warren on Sept 7, 2010 at 12:00EDT. This beginner to intermediate level session will introduce you to statistics, including how to create, manage, troubleshoot, and more!  Read more...
By Press Release 2010/09/03 | Source: | Category: webinar
Rating: (not yet rated) |  Discuss |   Briefcase | 4,040 reads

How Old Are Your Database Statistics?

Unlike fine wine, database statistics do not improve with age. I recently helped out with a client who was having...  Read more...
By GlennBerry 2010/09/02 | Source: | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,981 reads

Tips to Optimize Your SQL Statements - Part 1

Don't blame SQL Server if your SQL Statements perform badly! But where do you start to investigate the problem? This article is a primer on were to start looking when your SQL runs slowly.  Read more...
By Brian Ellul 2012/02/10 (first published: 2010/07/29) | Source: | Category: performance tuning
Rating: |  Discuss |   Briefcase | 44,967 reads

13 Things You Should Know About Statistics and the Query Optimizer

Fabiano launches into a sound technical explanation of the way that the query optimiser works in SQL Server with a mention of Brazilian Soccer stars and young ladies on Copacabana beach. You'll never quite think of statistics, execution plans, and the query optimiser the same way again after reading this, but we think you'll understand them better.  Read more...
By Additional Articles 2010/02/02 | Source: SimpleTalk | Category: statistics
Rating:  Rate this |   Briefcase | 5,632 reads

Index Primer - Just what statistics are kept?

An in-depth look at index statistics and how they are used by the optimizer by Josef Richberg.   Read more...
By Josef Richberg 2009/10/28 | Source: | Category: optimizer
Rating: |  Discuss |   Briefcase | 7,623 reads

Collecting Query Statistics for SQL Server 2005

With SQL Server 2005 DMVs, we can easily find query performance statistics. Every DBA has a favorite script to find query performance stats. I also have one. But, are all the queries captured by the DMVs? In this tip I will walk through capturing some of this data and show what is capture and what is not captured by the DMVs.  Read more...
By Additional Articles 2009/10/05 | Source: | Category: statistics
Rating:  Rate this |   Briefcase | 4,444 reads

Statistics Used by the Query Optimizer in Microsoft SQL Server 2008

Microsoft SQL Server 2008 collects statistical information about indexes and column data stored in the database. These statistics are used by the SQL Server query optimizer to choose the most efficient plan for retrieving or updating data. This paper describes what data is collected, where it is stored, and which commands create, update, and delete statistics. By default, SQL Server 2008 also creates and updates statistics automatically, when such an operation is considered to be useful. This paper also outlines how these defaults can be changed on different levels (column, table, and database).  Read more...
By Additional Articles 2009/07/24 | Source: TechNet Blogs | Category: query optimization
Rating: (not yet rated)  Rate this |   Briefcase | 2,199 reads

Retaining historical index usage statistics for SQL Server - Part 2

We look at performing the same task for the sys.dm_db_index_operational_stats Dynamic Management Function (or DMF.) The process is identical, the code is however quite different due to the structural differences between sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.  Read more...
By Additional Articles 2009/06/24 | Source:
Rating: (not yet rated)  Rate this |   Briefcase | 2,103 reads

Retaining historical index usage statistics for SQL Server

In this three-part series I'll look at what you can do to persist this data so you don't find yourself waiting for usage stats to compile over a reasonable period of time just so you can harness the power of the indexing DMOs in your performance tuning process.   Read more...
By Additional Articles 2009/05/26 | Source: | Category: statistics
Rating: (not yet rated)  Rate this |   Briefcase | 1,083 reads

Index Metadata and Statistics Update Date for SQL Server

Statistics update date is stored as metadata on the SQL instance, but after a great deal of research against the system tables and DMVs I realized that this information is not readily exposed to the DBA via any other method than the STATS_DATE() function or the SQL Server Management Studio graphical user interface (GUI).  Read more...
By Additional Articles 2008/08/12 | Source: | Category: indexing
Rating: (not yet rated)  Rate this |   Briefcase | 2,651 reads

Rebuilding Stats: Twice or Not At All

Are you rebuilding statistics twice on your tables? Longtime expert, Andy Warren, shows why you might be asking more work of your SQL Server than is required.  Read more...
By Andy Warren 2008/07/29 | Source: | Category: indexing
Rating: |  Discuss |   Briefcase | 8,911 reads

Statistics and Indexes

When is it okay to let SQL Server to make a statistic for columns in your queries, and when should you take those statistics and make an index out of them? What I do is to test all of my procs, and if they generate system statistics (_WA_SYS%), then I add an index to the table for the column in the statistic. But is this a good practice?  Read more...
By Additional Articles 2008/03/11 | Source: SQL Community | Category: indexing
Rating:  Rate this |   Briefcase | 3,314 reads
<< Newer    Items 21 to 35 of 35