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…
Category Archives: Customers
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…
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…
Backups and Disk Space
I was in Phoenix last week to visit a customer, and I saw an email come through regarding a customer who contacted support because they discovered they were missing data from a table. The customer contacted support on Friday morning and our team was engaged almost immediately. The data loss had been discovered on Thursday…
