My idea for this month’s T-SQL Tuesday came from a book I read many years ago, Water Cooler Diaries: Women across America Share Their Day at Work. I don’t remember how I found the book, but I thoroughly enjoyed it. As I said in my original post, I like knowing what people do, and this…
Continue Reading »
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 »
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…
Continue Reading »