THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » statistics   (RSS)
Showing page 2 of 4 (35 total posts)
  • Geek City: More statistics info available!

      I just started using a new DMV (one that’s actually an ‘F’ not a ‘V’, as in Function) that gives us more info about distribution statistics. It returns info about the last statistics update date (which is also available with a function STATS_DATE()). It also provides the number of rows sampled when the statistics were last updated. This is ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on April 9, 2013
  • Geek City: Accessing Distribution Statistics

    Distribution statistics are one of the most important sources of information that the Query Optimizer uses to determine a good query plan. In this post, I’m not going to tell you everything about distribution statistics. I’m just going to show you a few tricks for getting access to the statistics. If you want a deeper understanding of what the ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on January 18, 2013
  • Decoding STATS_STREAM

    Data distribution statistics is one of the foundations of the cost-based query optimizer in all modern database engines including SQL Server. From SQL Server 2005 on, most of the information displayed by DBCC SHOW_STATISTICS is kept in a binary field accessible with the STATS_STREAM clause. Back in SQL Server 2000, it was possible to modify ...
    Posted to Joe Chang (Weblog) by jchang on May 5, 2012
  • Connect Digest : 2011-09-22

    Where is SYSDATE()? I've talked about this one before, but due to a recent conversation about building a datetime value from separate date/time columns or variables, it may be worth bringing up again. When SQL Server 2008 introduced several new date/time types, they also added new built-in functions, like SYSDATETIME() and SYSDATETIMEOFFSET(). ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on September 22, 2011
  • How to Find the Statistics Used to Compile an Execution Plan

    In this post, I show you how to determine exactly which statistics objects were used by the query optimizer to produce an execution plan. Trace Flags We will need three undocumented trace flags.  The first one (3604) is well-known – it redirects trace output to the client so it appears in the SSMS messages tab. The second trace flag is ...
    Posted to Paul White: Page Free Space (Weblog) by Paul White on September 20, 2011
  • Ola Hallengren adds STATISTICS support to his solution

    Last week, Ola published a very useful update to his Backup, Integrity Check and Index Optimization scripts: the solution now supports updating statistics.  There are several options, such as only updating when the data has been modified and using the RESAMPLE and NORECOMPUTE options.  An example call: EXEC ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on December 13, 2010
  • Fooling the Query Optimizer

    Did you ever wanted to know which execution plans the Query Optimizer would generate for your queries should your tables have millions of records? You can actually generate those plans by using the undocumented ROWCOUNT and PAGECOUNT options of the UPDATE STATISTICS statement. These options can be used on small or empty tables and can be ...
    Posted to Benjamin Nevarez (Weblog) by Ben Nevarez on January 13, 2010
  • Lies, Damned Lies and Statistics – Part III (SQL Server 2008)

    In previous posts (http://sqlblog.com/blogs/elisabeth_redei/archive/2009/08/10/lies-damned-lies-and-statistics-part-i.aspx  and http://sqlblog.com/blogs/elisabeth_redei/archive/2009/03/01/lies-damned-lies-and-statistics-part-ii.aspx)I have talked about the performance problems that may surface because of low statistics sample rate on large ...
    Posted to Elisabeth Redei (Weblog) by Elisabeth Redei on December 17, 2009
  • For want of a nail

    For want of a nail the shoe was lost. For want of a shoe the horse was lost. For want of a horse the rider was lost. For want of a rider the battle was lost. For want of a battle the kingdom was lost. And all for the want of a horseshoe nail.   I'm now in the middle of severity A case that is best depicted by this ...
    Posted to Michael Zilberstein (Weblog) by mz1313 on December 7, 2009
  • Rebuilding Indexes vs. Updating Statistics

    One of the questions I was asked recently while speaking at user groups, was regarding the order that jobs like rebuilding indexes or updating statistics should be performed as part of the database maintenance activities. Then I started writing this post about this topic on the weekend but was interrupted several times, including one of them to ...
    Posted to Benjamin Nevarez (Weblog) by Ben Nevarez on October 6, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement