April 13, 2012 at 12:49 am
Hi all,
In our server (SQL 2008 Standard) we are facing a problm with one table.
Issue:It is having 740 rows.These row we have updated last month.This month agian we have updated 484 records.
Now i have checked Updated statistics.Itis not shoeing the updated date.IT is showing Last update Date.We have set the status for Auto update statistics is TRUE.Remain all tables are showing updates correctly.
This table is having a clusterd index and the fragmentation percenatge is 96%. But other tables which is having more than 90% fragmentation they are getting update.
Please support to findout the issue.
April 13, 2012 at 5:23 am
Minto Minto(quendans) (4/13/2012)
In our server (SQL 2008 Standard) we are facing a problm with one table.Issue:It is having 740 rows.These row we have updated last month.This month agian we have updated 484 records.
Please support to findout the issue.
I guess no query has been run which need that statistics.
Database engine updates the stats when a query needs it. Not just when data is changed.
What problem/issue are you facing because of old stats?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply