Seems I managed to make it through all of April without an update to the index analysis stored procedure. It wasn't for lack of using it with clients, but a lack of time to get the changes out the door. A few months back, I added the option to look at just duplicate index or … Continue reading Index Analysis May Update
After this month's Index Analysis update, I was contacted by a reader about the index analysis script. Reader Dick Baker let me know that he found and had a fix for an issue with the missing_index_impact column. Thanks to Dick for this fix. If you find issues or have suggestions for changes to the script, please … Continue reading A Second March ‘Index Analysis’ Update
In yesterdays duplicate index blog post, I mentioned that there would be an update to the index analysis stored procedure today. Without further ado, you can jump to the bottom and download it. There are a few things I've fixed from comments from people using the script and then major change is the addition of … Continue reading Index Analysis March Update
As I've worked with clients on performance tuning through index improvements, one of the common areas that I discuss with them are duplicate indexes. The problem with duplicate indexes is that they are pointless and redundant. All they provide is an additional physical copy of the index and all you get is another index for … Continue reading That’s Actually A Duplicate Index
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 … Continue reading Index Analysis Update – January 2012
Finally up to the last post of this series resurgence. Time to update the Index Analysis Custom Report that I developed last year. 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 … Continue reading Return of the Index Analysis Report
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 … Continue reading Return of Index Analysis Part 5
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 … Continue reading Return of Index Analysis Part 4
Time for part three of my continued Index Analysis query. The previous posts in this 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 Analyze Your Indexes Part 3 – Find the relationship … Continue reading Return of Index Analysis Part 3
Time for part two of my continued Index Analysis query. The previous posts in this 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 Analyze Your Indexes Part 3 – Find the relationship … Continue reading Return of Index Analysis Part 2
Strate SQL 