Rob Farely has posted a great article on why your covering indexes in SQL Server may not be getting the perfomance you are expecting.
Covering, schmuvvering – when a covering index is actually rubbish
If you use covering indexes but SQL Server keeps ignoring them – read Rob’s article for some reasons why.