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

Articles with tag statistics Rss

Search for any content tagged statistics

   Items 1 to 20 of 35    Older >>
 

How to Identify Useful SQL Server Table Statistics

In this article, Fikrat Azizov describes the different approaches to maintaining statistics and shows how you can use the data from your servers for intelligent statistics updates.  Read more...
By Additional Articles 2016/06/01 | Source: MSSQLTips.com | Category: tables
Rating: (not yet rated)  Rate this |   Briefcase | 2,885 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,630 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,167 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,514 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,264 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,234 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,167 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,880 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,473 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,313 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,841 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: Redgate | Category: oracle
Rating: (not yet rated) |  Discuss |   Briefcase | 2,640 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: Redgate | Category: oracle
Rating: (not yet rated) |  Discuss |   Briefcase | 2,640 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: Redgate | Category: oracle
Rating: (not yet rated) |  Discuss |   Briefcase | 2,640 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: Redgate | Category: oracle
Rating: (not yet rated) |  Discuss |   Briefcase | 2,640 reads

How to Find Outdated Statistics in SQL Server 2008

How can I find out which statistics are outdated in my SQL Server database?  Read more...
By Additional Articles 2012/09/06 | Source: MSSQLTips.com | Category: statistics
Rating: (not yet rated)  Rate this |   Briefcase | 3,297 reads

Tips to Optimize Your SQL Statements - Part 1

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 | 44,952 reads

Statistics on Ascending Columns

It comes as rather a shock to find out that one of the commonest circumstances in an OLTP database, an ascending primary key with most querying on the latest records, can throw the judgement of the Query Optimiser to the extent that perfomance nose-dives. Fabiano Amorim once again dons snorkel and goggles to explore the murky depths of execution plans to find out why.  Read more...
By Additional Articles 2011/09/16 | Source: SimpleTalk | Category: statistics
Rating:  Rate this |   Briefcase | 2,299 reads

Questions About SQL Server Distribution Statistics

Fabiano Amorim was asked a couple of questions about SQL Server Distribution Statistics. Having given an answer based on his current knowledge, he then decided to find out for himself whether what he'd said was right, and started an epic journey of exploration into Distribution Statistics and the way that the Query Optimiser uses them.  Read more...
By Additional Articles 2011/07/13 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 1,904 reads
   Items 1 to 20 of 35    Older >>