| Author |
Wrong Record Count
|
|
|
| The number of rows shown in SELECT COUNT(*) statement is different from the
number displayed on table property. I know the number returned by select
statement is correct. How do I correct it? I have tried DBCC CHECKDB with
REPAIR_ALLOW_DATA_LO
SS option.
| |
| David Gugick 2005-10-28, 1:23 pm |
| eAW wrote:
> The number of rows shown in SELECT COUNT(*) statement is different
> from the number displayed on table property. I know the number
> returned by select statement is correct. How do I correct it? I have
> tried DBCC CHECKDB with REPAIR_ALLOW_DATA_LO
SS option.
That information is not kept real time. You can try using DBCC
UPDATEUSAGE to update those stats.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com
| |
|
| how about running DBCC UPDATEUSAGE
------------------------------------------------------------------------------------------
"I sense many useless updates in you... Useless updates lead to
fragmentation... Fragmentation leads to downtime...Downtime leads to
suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG
and DBCC DBREINDEX are the force...May the force be with you" --
http://sqlservercode.blogspot.com/
| |
| Paul S Randal [MS] 2005-10-28, 8:23 pm |
| What prompted you to run REPAIR_ALLOW_DATA_LO
SS?
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"eAW" <anwang@mailcity.com> wrote in message
news:Oj93xQ%232FHA.3276@TK2MSFTNGP10.phx.gbl...
> The number of rows shown in SELECT COUNT(*) statement is different from
> the number displayed on table property. I know the number returned by
> select statement is correct. How do I correct it? I have tried DBCC
> CHECKDB with REPAIR_ALLOW_DATA_LO
SS option.
>
| |
| David Gugick 2005-10-28, 8:23 pm |
| Paul S Randal [MS] wrote:
> What prompted you to run REPAIR_ALLOW_DATA_LO
SS?
>
I assume the OP thought this information was always kept up to date.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com
|
|
|
|