May 27, 2009 at 4:43 am
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
May 27, 2009 at 5:13 am
they match for me.
not sure why they differ for you.
May 27, 2009 at 5:55 am
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..
May 27, 2009 at 5:56 am
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.May 27, 2009 at 9:19 am
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 opportunities brilliantly disguised as insurmountable obstacles.
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