I have a pretty huge job which run normally for 1hr max on a SS2000. Lately, after bringing over the database to SS2005,the job goes running over 1day!!This job performs quite a lot of updates on a particular table.We updated the stats and the next day it completed in 45 mins!! The next 2 days after that, the job hung again. The autoupdate stats for the indexes in that table is turned on.And I can see a few stats getting updated(EXEC sp_autostats) and some others aren't (even though autostats are turned on for the table and the database).To fix it I had to run the update stats(UPDATE STATISTICS <table> WITH FULLSCAN,ALL) and run the job. I can't be doing a manual stats update everyday. Has any one come over this issue where SS2005 does not update stats on their server? I am on SS2005 enterprise with SP2.