StephenNL (6/12/2014)
I am thinking about updating statistics regularly now.
Don't just think about it. 😀
The reason it helped here is that the 2005+ statistics have a different structure than the 2000 ones. While the newer optimiser can use the older stats, it doesn't do so efficiently, so updating all stats is near-essential when upgrading from 2000.
What would you recommend for a time table if the query is used very often ?
A what?
What about rebuiding indexes or reorganizing indexes ?
I think it's a good idea.
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