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 [...]
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 [...]
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 [...]
Earlier this year, I finally passed the Microsoft Certified Master (MCM) for SQL Server 2008 certification. In the process of preparing for the MCM lab portion, I did a lot of studying. One of the my key resources, were the MCM Readiness Videos that SQLSkills put together a couple years back. The thing is, even if [...]
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 [...]
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 [...]
A couple years back, I wrote a few blog posts about an indexing script that I use with clients from time to time. While I provided some updates to it over the years, I haven’t pushed out anything new on it in quite some time. Seems I got distracted with an indexing book and never [...]
What would you say if I offered you the best indexing book on the market for SQL Server 2012? Wow, right? The “best” indexing book! Unfortunately, this is also the “worst” indexing book. Coincidentally, it is also the “only” indexing book for SQL Server 2012. And even though the book was written with SQL Server [...]
A while back I was asked, if you can use the plan cache to determine which plans are using specific indexes. The answer is, of course, yes, you can. And it’s important that people, especially DBAs, understand how to do this. Usually during index analysis, we concern ourselves with whether an index is being used. [...]
Follow the rest of this series at the Can You Dig It? – Plan Cache series introduction post. It’s been a while since the last plan cache series post. In the last few posts, I was focusing on specific attributes. Instead of continuing on that vein, I want to cover a use case that fit [...]
_1262.png)
