• Also if you're just adding single column indexes all over the place, you might be hurting yourself without knowing it. Are you adding the indexes based on the execution plans and do you know that, after adding the index, that performance improves, or are you making assumptions? The best way to solve this issue is through lots of gathered metrics so you know which queries are run most frequently, which will benefit from specific indexes and which won't and begin to narrow down what you're maintaining. Also, do you have a clustered index on the table? Is it the most frequently used access point to the data?

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning