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.