Monthly Archives: April 2012

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…

A Consideration When Rebuilding a Corrupt NonClustered Index

This past weekend I was in Madison, WI for SQLSaturday #118 and it was a fantastic event.  Jes Borland ( b | t ) and her team did a great job of hosting their first SQLSaturday and I was honored to present twice.  I presented a new session, DBCC Commands: The Quick and the Dangerous,…