Luke L (5/2/2008)
Just out of curiosity, do you have auto-stats turned on? Is it not doing a good enough job for you?
You can see the following from BOL to get more information on updating statistics.
You could use the example to update all the stats for a particular table and wrap that inside of the undocumented sp_MSforeachTable stored procedure to recompute stats for all of your tables...
Can you please let me know how to check the details of update statistics which ran on database after a particular date.
Ex: How to find on which tables update stats ran after jun27th on a particular database ?