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…
Continue Reading »
Originally written Thursday, March 3, 2011. As I type, I’m flying home from a three day customer site visit, listening to the movie Miracle on my iTouch. My day didn’t end well. Before we left the customer site we had a meeting with a technical representative from another Independent Software Vendor (ISV), and the interaction…
Continue Reading »
Today I’m flying out to visit one of our customers for a few days. Usually when I go to a customer site I’m looking at solution performance, but this customer requested that we come on site to review their solution and make Disaster Recovery (DR) recommendations. I love going to customer sites for a variety…
Continue Reading »