I’ve seen a few scripts knocking around to remove unused indexes. I’ve had a sneaky feeling in the past about this and whether it would actually make any difference or not, but here’s my experience:
DO NOT REMOVE INDEXES BASED ON THESE SCRIPTS IN SQL SERVER 2005. Sorry about the shouting.
I have seen at a couple of sites that removing indexes has deteriorated queries that were using them. Unfortunately the appropriate dmv wasnt logging this use. A further investigative post methinks.