Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Indexing, statistics Rss

   Items 1 to 9 of 9   
 

Tips to optimize your SQL statements

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: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 40,668 reads

Missing Indexes By Index Advantage

Identifies potentially missing indexes.  Read more...
Rating: |  Discuss |   Briefcase | 3,902 reads

List Unused Tables and Indexes

Finds tables and indexes that do not show up in the usage statistics.  Read more...
Rating: |  Discuss |   Briefcase | 3,122 reads

Tips to optimize your SQL statements

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: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 40,668 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: SQLServerCentral.com | Category: optimizer
Rating: |  Discuss |   Briefcase | 7,595 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: MSSQLTips.com | Category: statistics
Rating: (not yet rated)  Rate this |   Briefcase | 926 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: MSSQLTips.com | Category: indexing
Rating: (not yet rated)  Rate this |   Briefcase | 2,482 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: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 8,896 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,281 reads
   Items 1 to 9 of 9   
 
Tags
dmv (2)    
density (1)    
distribution (1)    
optimizer (1)    
performance tuning (1)    
t-sql (1)