Difference in rowcount with select and Table properties?

  • Hi,

    I have observe that, when I run a query using select * from tablename it returns say 7800 rows and when i check table properties --> General --> Storage --> Row count displays 8600 rows............. why is this differing in numbers.

    if you run any huge table u can see this differnce.

    If any one have any idea on this.

    Thanks,

    Raj

  • they match for me.

    not sure why they differ for you.

  • HI davidandrews13

    its different me for also

    when i execute select * from [User] it displays 16153rows in right bottom corner of Result Grid

    If go through the Table properties

    its showing 206658

    plz help me in finding the reason for the difference..

  • Do you have automatic statistics gathering enabled for the offending table?

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
  • You need to update the usage on that database. I would bet anything the database was upgraded from SQL Server 2000 and you have never run an update usage.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply