Statistics

Rebuilding Indexes Will Reset Index Usage Statistics in SQL Server 2012

Rebuilding Indexes Will Reset Index Usage Statistics in SQL Server 2012

We all know that statistics get updated when you rebuild your indexes, right? OK, for those of you that are not aware of such things here is a blog post from Benjamin Nevarez (blog | @BenjaminNevarez) on the topic. He does a great job of explaining the subtle differences involved with various index and statistics(…)

Predictive Analysis: I Bet You Didn’t Know I Would Blog This Today

Predictive Analysis: I Bet You Didn’t Know I Would Blog This Today

Quick question: Where would you go to find some basil in your local grocery store? Did you say “by the other herbs?” Or did you say “by the tomatoes?” If you are like me, then you would go looking for basil by the other herbs because, well, that is a natural, logical grouping of products.(…)

The 6 Performance Tuning Mistakes You Don’t Want to Make

The 6 Performance Tuning Mistakes You Don’t Want to Make

We’ve all had those moments. It’s late in the day. You are about to head home a few minutes early so you can bring your daughter to soccer practice on time. Your phone rings. The voice on the other end of the line mutters something about the server “being slow”, and needs you to fix(…)