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

Content with tag statistics Rss

   Items 1 to 20 of 66    Older >>
 

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 | 74 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 | 3,991 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,411 reads

Trace Flags

By S M 2014/11/18 | Category: statistics
Rating: (not yet rated) |  Discuss |   Briefcase | 1,434 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,339 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,194 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,581 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,339 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,339 reads

Updating Statistics

By Steve Jones 2014/03/14 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,793 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 2014/03/10 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 8,820 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,627 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,411 reads

Auto Create Statistics

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

SQL Server Statistics Questions We Were Too Shy to Ask

If you need to optimise SQL Server performance, it pays to understand SQL Server Statistics. Grant Fritchey answers some frequently-asked questions about SQL Server Statistics: the ones we somehow feel silly asking in public, and think twice about doing so.  Read more...
By Additional Articles 2013/03/12 | Source: SimpleTalk | Category: statistics
Rating:  Rate this |   Briefcase | 3,191 reads

SQL Server Statistics Questions We Were Too Shy to Ask

If you need to optimise SQL Server performance, it pays to understand SQL Server Statistics. Grant Fritchey answers some frequently-asked questions about SQL Server Statistics: the ones we somehow feel silly asking in public, and think twice about doing so.  Read more...
By Additional Articles 2013/03/01 | Source: SimpleTalk | Category: statistics
Rating:  Rate this |   Briefcase | 3,708 reads
   Items 1 to 20 of 66    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 plan (1)    
integrity check (1)    
kurtosis (1)    
metadata (1)    
metrics (1)    
optimizer (1)    
oracle (1)    
performance monitoring (1)    
quartiles (1)    
r language (1)    
range (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)