• Don't bow. You're right. 100%.

    I think most of us have been focused on the indexes. I'm still a bit bothered by the cluster being on such non-selective columns. It's not going to group the data well. Still, I'd have to see execution plans or a structure with statistics to really pass judgement on which way all these indexes should go. However, the short answer, there are definately some you don't need and there are likely more that won't or can't get used by the optimizer. You have to look at the selectivity of all these indexes to determine if they are actually useful. Then you have to examine the execution plan to see if they are actually used. As much as anything else, that will tell you what to do.

    "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