Since I’ve rewritten sp_helpindex a few times, I have a few blogs posts in this category. Each time I do an update I’ll make the NEW version titled USE THIS and I’ll change all others to (OLD). The point of this updated version of sp_helpindex is to add details for newer functionality (included columns and […]
Kimberly L. Tripp
Improving my SQL skills through your questions!
USE THIS: sp_helpindex
Posted on: February 27, 2017 11:02 pm
(OLD): New SQL Server 2012 rewrite for sp_helpindex
Posted on: September 10, 2013 10:55 am
Since I’ve rewritten sp_helpindex a few times, I have a few blogs posts in this category. Each time I do an update I’ll make the NEW version titled USE THIS. To use my version of sp_helpindex, you need TWO scripts. One script is version-specific and the other works on versions 2005, 2008/R2 and 2012. All […]
Removing duplicate indexes
Posted on: July 15, 2011 8:47 am
SQL Server has a horrible habit of letting bad habits move forward (for the sake of backward compatibility [e.g. autoshrink]). And, I do understand *some* of the reasons for allowing some of these “features/options” to move forward. However, there are a few that frustrate me and I’ve talked about this one quite often. SQL Server […]
How can you tell if an index is REALLY a duplicate?
Posted on: July 14, 2011 11:39 am
There’s a lot of confusion around duplicate indexes and I think a lot of it has to do with how sp_helpindex (or even SSMS) display what’s in an index. What’s actually in the index – and how it’s structured – are not always what they seem. This was the original motivation behind my rewrite of […]
(OLD): sp_helpindex rewrites
Posted on: February 27, 2011 11:45 am
I realize that I’ve created quite a few posts (and rewrites) around sp_helpindex and recently I’ve been recommending that most folks use my latest version (jokingly, this is sp_helpindex9) but it’s not so obvious where to get it and/or what to do to install it. To make it easier… I’m just going to do a […]
How much does that key cost? (plus sp_helpindex9)
Posted on: November 12, 2010 8:27 am
OK, two in two days? What's wrong with me (is what Paul said) after he said – who are you and where is my wife? But, this one is a short one, specifically a follow-on to my prior post about "Disk space is cheap…" I did a bit of simple math on the internal overhead and […]
(OLD): A new and improved sp_helpindex (jokingly sp_helpindex8)
Posted on: May 18, 2010 8:33 pm
NOTE: I’ve released other versions of sp_helpindex since this post. Check out the category: sp_helpindex rewrites for all of the options! OK, I first blogged about re-writing sp_helpindex here as sp_helpindex2 (April 2008). Shortly thereafter (Aug 2008), a reader found a bug and when I went digging, so did I (a couple of others). I did […]
(OLD): Updates (fixes) to sp_helpindex2
Posted on: August 24, 2008 7:23 pm
NOTE: I’ve released other versions of sp_helpindex since this post. Check out the category: sp_helpindex rewrites for all of the options! I first posted an update to sp_helpindex here. My version of sp_helpindex was solely to expand what sp_helpindex showed and adds 1 or 2 things based on version: for SQL2005+ it adds included columns and […]
(OLD): sp_helpindex2 to show included columns (2005+) and filtered indexes (2008) which are not shown by sp_helpindex
Posted on: April 2, 2008 6:22 pm
IMPORTANT NOTE: Always check the sp_helpindex rewrites category for the USE THIS post! OK – so this has been frustrating me for many months… when you create indexes with included columns (which was a new feature of SQL Server 2005), they’re not shown by sp_helpindex or by DBCC SHOW_STATISTICS. I understand this not showing for […]
