SQL INDEX Performance

When does an index on a column potentially hurt performance?