SQL Server Performance

# of Rows discrepance in Table properties

Discussion in 'General DBA Questions' started by rweinstein, Jun 20, 2005.

  1. rweinstein New Member

    Hello,

    I remember seeing a post here a while back related to this, but I am not able to remember the fix or find the post. I am testing a process that delivers exactly 6422 rows to an empty table with two software solutions.

    They both deliver the exact amount of data, they both are dlivering 6422 identical rows. However, when I go into one of the table properties, it says the table has only 6399 rows.

    I updated statistics and it still says 6399 rows??

    I am looking at the table properties in Enterprise Manager.

    Does anyone know why the table properties show a discrepancy, how I can fix this so the table shows the # of correct rows, etc?

    Thanks.

    Rodney
  2. Argyle New Member

    dbcc updateusage(0)
  3. rweinstein New Member

    Thanks, Argyle! It worked. Is it okay to include this in my execution of the weekly update statistics? Should I run this stored procedure before or after I update stats?

    Thanks.
  4. satya Moderator

    If you run DBCC DBREINDEX then it should be updated too and keep in mind if you're running UPDATEUSAGE on a large table then it may takeup some time to update. Anyways no issues in using in production database.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page