index

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(…)

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(…)

How To Improve Database Performance Without Changing Code

How To Improve Database Performance Without Changing Code

I hear it all the time. It’s a familiar refrain. Most of the time it is innocent enough, and understandable. But there are times when hearing those words are like hearing the screech of fingernails on a chalkboard: “We can’t change the code.” There you are, listening to someone complain to you about the database(…)