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 (38 total posts)
  • Stats on Stats

    I have been working on new features for the Rules-Driven Maintenance Solution, including per-index maintenance preferences and more selective processing for statistics. SQL Server stats is a topic I knew about at a high level, but lately I have had to take a deeper dive into the DMVs and system views and wrap my head around things like ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on September 18, 2013
  • Geek City: How old are my statistics?

    This post is basically to answer a question asked in class this week: How can we get the last statistics update date for ALL user tables in a database? After working on the query for a while, I realized that the new metadata function I posted about here can give you that info easily: SELECT object_name(sp.object_id) as object_name,name as ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on August 31, 2013
  • Did You Know? What settings to always change

      A week ago, I taught my SQL Server 2012 Internals class to a great group of very interactive students. Even though a dozen of them were taking the class remotely, there were still lots of really great questions and and lots of discussion. One of the students asked if I could summarize all the settings that I recommended changing from the ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on June 25, 2013
  • 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 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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement