August 25, 2005 at 6:50 am
I copied 2 big tables from our test server to production overnite. I compared counts by clicking on table properties. The count for the first table matched exactly (51,016,636). The second table had a discrepancy even though the job ran successfully (8,571,364 versus 8,571,000). I was just going to recopy that table by itself but first I did a select count(*) in QA and got the correct count. Therefore, the count in properties in EM differs from QA.
I did an UPDATE STATISTICS on that table hoping that would change it in properties, but no dice.
I would like the counts to agree without recopying if possible because I have 6 more years of data to load into this database.
Does anyone have any thoughts?
Thanks.
Randy
August 25, 2005 at 6:52 am
Try restarting EM (simple refresh might be enough).
August 25, 2005 at 6:56 am
Thanks, I already tried that with no luck.
August 25, 2005 at 6:57 am
how about sp_updatestats??
August 25, 2005 at 7:05 am
Just tried, didn't fix it.
August 25, 2005 at 7:10 am
And you restarted EM???
No clue what's wrong. Maybe with a bigger sampling of the data, it would work.
August 25, 2005 at 8:12 am
Try using dbcc updateusage.
--JP
August 25, 2005 at 9:17 am
Table Properties in Ent Mgr is not reliable. You should use "select count(*) from table" to get accurate results.
August 25, 2005 at 9:19 am
He obviously knows since he already did update statistics.
August 25, 2005 at 11:48 am
Try using dbcc updateusage.
--JP
-----------------------------------------
This worked. Thanks JP.
I thought there must be a simple solution.
August 25, 2005 at 11:51 am
Looks like I got to open up BOL for this one .
Viewing 11 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy