Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Difference in rowcount with select and Table properties? Expand / Collapse
Author
Message
Posted Wednesday, May 27, 2009 4:43 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, April 5, 2014 1:58 AM
Points: 48, Visits: 198
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
Posted Wednesday, May 27, 2009 5:13 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Today @ 9:12 AM
Points: 603, Visits: 3,526
they match for me.
not sure why they differ for you.
Post #723965
Posted Wednesday, May 27, 2009 5:55 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Posted Wednesday, May 27, 2009 5:56 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,065, Visits: 4,639
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
Posted Wednesday, May 27, 2009 9:19 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 12:19 PM
Points: 4,360, Visits: 9,543
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 »

Add to briefcase

Permissions Expand / Collapse