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

Content with tag statistics Rss

   Items 1 to 20 of 72    Older >>
 

Automatic update of outdated statistics

By Uwe Ricken 2016/02/24 | Category: statistics
Rating: (not yet rated) |  Discuss |   Briefcase | 1,301 reads

A Lightweight, Self-adjusting, Baseline-less Data Monitor

Can data alert us that something is going on, without baselines and thresholds?  Read more...
By Alex Chamchourine 2016/02/23 | Source: SQLServerCentral.com | Category: data monitoring
Rating: |  Discuss |   Briefcase | 2,580 reads

Enhanced Index Rebuild Script

Enhanced version of Index Rebuilt Script originally written by Michelle Ufford, which now includes latest version updates and additional features.  Read more...
Rating: |  Discuss |   Briefcase | 1,053 reads

Using the Statistical Program R for Running Statistics

This article talks about using the statistical program, R, for applying simple statistics against data in Microsoft SQL Server.  Read more...
By Tomaz Kastrun 2016/01/29 (first published: 2014/03/10) | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 12,081 reads

Custom Built Statistics

Dan Holmes shows how you can create statistics exactly the way you want within the bounds of the 200 steps available.  Read more...
By Additional Articles 2015/12/09 | Source: SQLPerformance.com | Category: statistics
Rating: (not yet rated)  Rate this |   Briefcase | 2,485 reads

Duplicate Stats

Give list of Duplicate Stats up to 9 cols...not just dupes but also covering...if one stats covers another its listed. Given pair only listed once if dupe.  Read more...
By John Heimiller 2015/08/26 | Source: SQLServerCentral.com | Category: statistics
Rating: |  Discuss |   Briefcase | 865 reads

Who Cares About Your Data?

The observation that people hear what they want to hear is not a new one, and yet the extent to which people will go out of their way to ignore or misinterpret evidence can still surprise.  Read more...
By Dave Convery 2015/06/01 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 80 reads

How to Categorize Uncategorized Data

Using SQL to perform cluster analysis to gain insight into data with unknown groups  Read more...
By Stephan Calderon 2015/04/16 | Source: SQLServerCentral.com | Category: cluster analysis
Rating: |  Discuss |   Briefcase | 4,225 reads

Dynamically create drop user statistics scripts

Generate script to drop any unwanted user created statistics.  Read more...
By David Kranes 2015/02/24 | Source: SQLServerCentral.com | Category: statistics
Rating: |  Discuss |   Briefcase | 1,457 reads

Trace Flags

By S M 2014/11/18 | Category: statistics
Rating: (not yet rated) |  Discuss |   Briefcase | 1,472 reads

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014.  Read more...
By Ola Hallengren 2014/10/20 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 44,545 reads

Getting the Most out of Statistics

Statistics keep track of our data and will tell SQL Server how to make the best optimization decisions. Knowing how they work can make understanding query and performance problems much easier!  Read more...
By Edward Pollack 2014/06/09 | Source: SQLServerCentral.com | Category: statistics
Rating: |  Discuss |   Briefcase | 5,231 reads

Generated script to update statistics

Generated script to update statistics  Read more...
By Andrés Michaca 2014/05/02 | Source: SQLServerCentral.com | Category: statistics
Rating: |  Discuss |   Briefcase | 1,672 reads

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014.  Read more...
By Ola Hallengren 2014/10/20 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 44,545 reads

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014.  Read more...
By Ola Hallengren 2014/10/20 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 44,545 reads

Updating Statistics

By Steve Jones 2014/03/14 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,825 reads

Using the Statistical Program R for Running Statistics

This article talks about using the statistical program, R, for applying simple statistics against data in Microsoft SQL Server.  Read more...
By Tomaz Kastrun 2016/01/29 (first published: 2014/03/10) | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 12,081 reads

Reduce Time for SQL Server Index Rebuilds and Update Statistics

This tip will explore two features to speed up SQL Server index and statistics maintenance in the SQL Server Enterprise, Standard and Express editions.  Read more...
By Additional Articles 2014/01/31 | Source: MSSQLTips.com | Category: indexing
Rating:  Rate this |   Briefcase | 4,860 reads

Dynamically create drop user statistics scripts

Generate script to drop any unwanted user created statistics.  Read more...
By David Kranes 2015/02/24 | Source: SQLServerCentral.com | Category: statistics
Rating: |  Discuss |   Briefcase | 1,457 reads
   Items 1 to 20 of 72    Older >>
 
Tags
indexing (10)    
administration (8)    
blogs (5)    
dmv (5)    
query optimizer (3)    
sql server 2005 (3)    
t-sql (3)    
maintenance (2)    
performance (2)    
performance tuning (2)    
query optimization (2)    
sql server 2008 (2)    
webinar (2)    
ascending columns (1)    
auto_created (1)    
auto_update_stats (1)    
backup (1)    
best practices (1)    
cluster (1)    
cluster analysis (1)    
columns (1)    
data analysis (1)    
data exploration (1)    
data mining (1)    
data monitoring (1)    
data science (1)    
density (1)    
distribution (1)    
editorial (1)    
execution plans (1)    
fragmentation (1)    
index rebuilds (1)    
integrity check (1)    
kurtosis (1)    
metadata (1)    
metrics (1)    
optimizer (1)    
oracle (1)    
performance monitoring (1)    
quartiles (1)    
r language (1)    
range (1)    
reorganise (1)    
skew (1)    
sql server 2008 r2 (1)    
sql server 2012 (1)    
sql server 2014 (1)    
standard deviation (1)    
stored procedure (1)    
stored procedures (1)    
temporary tables (1)    
unknown groups (1)