Tag: Index Analysis

Lego Computer

Index Analysis Update – January 2012

In the past couple weeks, I’ve gotten a couple reports of issues with sp_indexanalysis.  The update today fixes those issues.  It’s fun to finally be playing with these scripts again.  I’m hoping to start writing blog posts showing the scripts in action in the next couple weeks. INDEX ANALYSIS UPDATES The main updates to the…

Lego Computer

Index Analysis Post Christmas Update

Last week I mentioned that I had put up a few new versions of my index analysis script.  Turns out a few people downloaded it and found some issues.  I also have been playing with it some more and noticed some quirks that were a bit irritating to me, so there are new versions of…

Lego Analyze

Return of Index Analysis Part 5

Alright, up to the last of the changes I’ve made to the index analysis query that I had planned.  This makes the fifth post in the series on this query. The previous posts in this complete series are: Analyze Your Indexes Part 1 – Combine existing index statistics and missing indexes into a single output…

Lego Analyze

Return of Index Analysis Part 4

We’ve got through the first three parts of this continued series on the Index Analysis query last week.  The previous posts in this complete series are: Analyze Your Indexes Part 1 – Combine existing index statistics and missing indexes into a single output Analyze Your Indexes Part 2 – Find existing duplicate and overlapping indexes…