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 69    Older >>
 

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 | 11,638 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,444 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 | 840 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 | 79 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,161 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,451 reads

Trace Flags

By S M 2014/11/18 | Category: statistics
Rating: (not yet rated) |  Discuss |   Briefcase | 1,465 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,504 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,221 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,660 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,504 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,504 reads

Updating Statistics

By Steve Jones 2014/03/14 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,817 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 | 11,638 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,805 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,451 reads

Auto Create Statistics

By Mike Hays 2014/01/07 | Category: statistics
Rating: (not yet rated) |  Discuss |   Briefcase | 1,700 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,504 reads

Managing SQL Server Statistics

Accurate statistics about the data held in tables are used to provide the best execution strategy for SQL queries. but if the statistics don't accurately reflect the current contents of the table you'll get a poorly-performing query. How do you find out if statistics are correct, and what can you do if the automatic update of statistics isn't right for the way a table is used?  Read more...
By Additional Articles 2013/04/15 | Source: SimpleTalk | Category: statistics
Rating: (not yet rated)  Rate this |   Briefcase | 6,447 reads
   Items 1 to 20 of 69    Older >>
 
Tags
indexing (10)    
administration (8)    
blogs (5)    
dmv (5)    
sql server 2005 (3)    
t-sql (3)    
maintenance (2)    
performance (2)    
performance tuning (2)    
query optimization (2)    
query optimizer (2)    
sql server 2008 (2)    
webinar (2)    
ascending columns (1)    
auto_created (1)    
backup (1)    
best practices (1)    
cluster (1)    
cluster analysis (1)    
columns (1)    
data analysis (1)    
data exploration (1)    
data mining (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)