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.