Monthly Archives: February 2012

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…

Vendor Feedback

I don’t know how many of you receive the SQLskills Insider email (sign up here), but if you know me, you know I’m a fan of SQLskills so of course I’m on the distribution list.  Anyway, in Monday’s email Paul Randal talked about application vendors and how he frequently hears about incorrect configuration recommendations made…