2 responses

  1. Joe Fleming
    September 22, 2011

    Erin’s session was indeed awesome at SQL Saturday #84, as we got to watch her troubleshoot an issue with statistics live!! Turns out it was an interesting artifact of having auto update stats off. I won’t spoil it in case she wants to do a blog post on it, but it was neat.

    I mentioned, incorrectly, at the session about a change in the way Auto Update stats will work in Denali. Turns out it’s actually a new feature of R2 SP1, a trace flag you can turn on to change when SQL will decide to update stats on larger tables. You can read about it here:

    http://blogs.msdn.com/b/saponsqlserver/archive/2011/09/07/changes-to-automatic-update-statistics-in-sql-server-traceflag-2371.aspx

    Many thanks to BrentOzarPLF for pointing me to this article, and a big round of applause for Erin for her awesome presentation on this topic!

  2. Erin Stellato
    September 23, 2011

    Thank you for the feedback Joe! I am glad you attended and really appreciate your follow up. Very interesting article, I will make sure to mention that tomorrow. So much good stuff out there on statistics :)

    Erin

    p.s. I couldn’t get the plan to drop from cache after turning auto update stats on. Something weird going on, haven’t had time to try and figure it out due to vacation, but I will and then I will write that post!

Leave a Reply

 

 

 

Notify me of followup comments via e-mail. You can also subscribe without commenting.

Back to top
mobile desktop