Category Archives: Customers

T-SQL Tuesday #32: A Day in the Life

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…

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…

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…