Accuracy of Results and sp

The values reported in the “pages” column may differ from the actual values. To determine whether the count is inaccurate, run sp_statistics and sp_helpartition to compare the data page count. The count provided by sp_statistics is always accurate.

If the page count reported by sp_statistics differs from the sum of the partition pages reported by sp_helpartition by more then 5 percent, run one of these commands to update the partition statistics:

dbcc checkdb
dbcc checktable
update all statistics
update table statistics

Then, rerun sp_helpartition for an accurate report.

Accuracy of Results and sp_helpartition