Without fail, when I am asked to look at indexes for a customer, I see duplicate and overlapping  indexes. While you may think this is not a big deal, (more indexes are better, right?) there are many performance implications. My latest article on SQL Authority shows what these indexes look like and how to clean them up.