Difference in rowcount with select and Table properties?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Difference in rowcount with select and Table...

Difference in rowcount with select and Table properties?

Rate Topic

Display Mode

Topic Options

Author

Message

draj108

Posted Wednesday, May 27, 2009 4:43 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 15, 2012 4:29 AM
Points: 48, Visits: 195

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

Post #723944

davidandrews13

Posted Wednesday, May 27, 2009 5:13 AM

SSC-Addicted

Group: General Forum Members
Last Login: Today @ 10:08 AM
Points: 457, Visits: 2,677

they match for me.
not sure why they differ for you.

Post #723965

ningaraju.n

Posted Wednesday, May 27, 2009 5:55 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, February 21, 2013 3:14 AM
Points: 134, Visits: 425

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..

Post #723983

PaulB-TheOneAndOnly

Posted Wednesday, May 27, 2009 5:56 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 12:00 PM
Points: 2,988, Visits: 4,412

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.

Post #723987

Jeffrey Williams 3188

Posted Wednesday, May 27, 2009 9:19 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, May 17, 2013 11:21 AM
Points: 4,317, Visits: 9,216

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
Problems are opportunites brilliantly disguised as insurmountable obstacles.

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

Post #724241

« Prev Topic | Next Topic »

Permissions