Has anyone dropped or changed an index?
Are any of the indexes fragmented?
Are the statistics up to date?
What does the execution plan of that query show?
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