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

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/03/21 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 41,317 reads

Updating Statistics

By Steve Jones 2014/03/14 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,612 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 | 7,760 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: index maintenance
Rating:  Rate this |   Briefcase | 4,326 reads

Dynamically create drop user statistics scripts

Generate script to drop any unwanted user created statistics.  Read more...
By David Kranes 2014/01/09 | Source: SQLServerCentral.com | Category: statistics
Rating: |  Discuss |   Briefcase | 806 reads

Auto Create Statistics

By Mike Hays 2014/01/07 | Category: statistics
Rating: (not yet rated) |  Discuss |   Briefcase | 1,582 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/03/21 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 41,317 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,229 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/03/21 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 41,317 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,084 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,545 reads

SQL Server 2008 Statistics: What does a DBA need to know?

I’ve been looking into the behaviour of statistics in SQL Server 2008 – so I’d like to present an overview from...  Read more...
By matt.bowler 2013/02/20 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 4,397 reads

What is DBCC SHOW_STATISTICS Telling Me About My Data?

Per Books Online, DBCC SHOW_STATISTICS displays current query optimization statistics for a table or indexed view.  Basically it shows you...  Read more...
By Patrick Keisler 2013/02/14 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,377 reads

Free Webinar: Statistics in Oracle and SQL Server

In their third live 'Oracle vs. SQL Server' discussion, Jonathan Lewis (Oracle Ace Director, OakTable Network) and Grant Fritchey (Microsoft SQL Server MVP) will look at statistics in Oracle and SQL Server. Expect a lively debate on Oracle vs. SQL Server from two leading RDBMS experts on Jan 23, 2013.  Read more...
By Press Release 2013/01/22 (first published: 2013/01/11) | Source: Red-Gate | Category: oracle
Rating: (not yet rated) |  Discuss |   Briefcase | 2,630 reads

Free Webinar: Statistics in Oracle and SQL Server

In their third live 'Oracle vs. SQL Server' discussion, Jonathan Lewis (Oracle Ace Director, OakTable Network) and Grant Fritchey (Microsoft SQL Server MVP) will look at statistics in Oracle and SQL Server. Expect a lively debate on Oracle vs. SQL Server from two leading RDBMS experts on Jan 23, 2013.  Read more...
By Press Release 2013/01/22 (first published: 2013/01/11) | Source: Red-Gate | Category: oracle
Rating: (not yet rated) |  Discuss |   Briefcase | 2,630 reads

Statistics Update Clarification

By default statistics are created automatically within SQL Server. And, by default, these stats are updated automatically based on a...  Read more...
By Grant Fritchey 2013/01/11 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,542 reads

Free Webinar: Statistics in Oracle and SQL Server

In their third live 'Oracle vs. SQL Server' discussion, Jonathan Lewis (Oracle Ace Director, OakTable Network) and Grant Fritchey (Microsoft SQL Server MVP) will look at statistics in Oracle and SQL Server. Expect a lively debate on Oracle vs. SQL Server from two leading RDBMS experts on Jan 23, 2013.  Read more...
By Press Release 2013/01/22 (first published: 2013/01/11) | Source: Red-Gate | Category: oracle
Rating: (not yet rated) |  Discuss |   Briefcase | 2,630 reads

Free Webinar: Statistics in Oracle and SQL Server

In their third live 'Oracle vs. SQL Server' discussion, Jonathan Lewis (Oracle Ace Director, OakTable Network) and Grant Fritchey (Microsoft SQL Server MVP) will look at statistics in Oracle and SQL Server. Expect a lively debate on Oracle vs. SQL Server from two leading RDBMS experts on Jan 23, 2013.  Read more...
By Press Release 2013/01/22 (first published: 2013/01/11) | Source: Red-Gate | Category: oracle
Rating: (not yet rated) |  Discuss |   Briefcase | 2,630 reads

Statistics - 4

By bitbucket-25253 2012/11/06 | Category: statistics
Rating: (not yet rated) |  Discuss |   Briefcase | 1,861 reads
   Items 1 to 20 of 58    Older >>
 
Tags
administration (8)    
indexing (8)    
blogs (5)    
dmv (5)    
t-sql (3)    
index maintenance (2)    
maintenance (2)    
performance tuning (2)    
query optimization (2)    
sql server 2005 (2)    
sql server 2008 (2)    
webinar (2)    
ascending columns (1)    
auto_created (1)    
backup (1)    
columns (1)    
data analysis; (1)    
data exploration (1)    
density (1)    
distribution (1)    
integrity check (1)    
kurtosis (1)    
metadata (1)    
metrics (1)    
optimizer (1)    
oracle (1)    
performance monitoring (1)    
quartiles (1)    
query optimizer (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 procedures (1)    
temporary tables (1)