Category Archives: Statistics

sysrscols and Disabling Auto Update Statistics

As I mentioned in my last post, one of the sessions I presented last weekend at SQLSaturday #118 was on statistics, and an interesting topic that came up toward the end of the session was the Auto Update Statistics option. I’ve blogged about this option before, and whether or not you leave it enabled for…

Statistics and Recompilations, Part II

I recently blogged about an interesting behavior in SQL Server when the database option, Auto Update Statistics, is disabled…and that post requires a sequel.  The summary is that when you have the Auto Update Statistics option disabled for a database, query plans for tables are not recompiled when their statistics are updated.  There is an…

Statistics and Recompilations

A couple weeks ago I was asked to look at system performance for a customer, and as part of my investigation I found a high read query.  I had run a trace and filtered for anything over 10,000 reads and saw a query that required around 32,000 reads, and it was running at least once…

Statistics at SQLSaturday #85

This week I’m on vacation with my family in sunny Orlando.  As luck would have it, the SQLSaturday powers-that-be scheduled SQLSaturday #85 here in Orlando this weekend.  I submitted a few sessions and had one selected!  If you want to learn about statistics, I would love to see you at my session, “You’re My Density:…