SQLNewbster (11/12/2009)
I did notice you mentioned clustered and I didn't have either as a clustered index.
A clustered index can't have include columns, just specify the key
I can try that one while I wait for another response..
Can you check the exec plan that you posted while waiting for a second opinion please? I don't think the current one shows what you think it shows.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability