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 […]
Kimberly L. Tripp
Improving my SQL skills through your questions!
Removing duplicate indexes
Posted on: July 15, 2011 8:47 am
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 […]
