Bradley B (7/20/2010)
you cannot do a covering index as the limit is 16 columns,
The 16 column limit is only on key columns, not on include columns.
balasach, please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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