Re: Table problem ?

Try updating manually the statistics, perhaps the problem canbe found here:

http://groups.google.de/groups?q=update+statistics+sql+server&hl=de&lr=&selm=5OAzWbPWEHA.3468%40cpmsftngxa10.phx.gbl&rnum=1


UPDATE STATISTICS <Name>


HTH, Jens Süßmeyer.

---
http://www.sqlserver2005.de
---

"Joh" <joh@xxxxxxxxxxxx> schrieb im Newsbeitrag
news:e0H%234tSQFHA.2252@xxxxxxxxxxxxxxxxxxxxxxx
>I have one table which name is medicalhistory which structure is as
>follows.
>
> ID int
> TId int
> TableName nvarchar(100)
> FieldName nvarchar(100)
> Comm1 nvarchar(4000)
> Comm2 nvarchar(4000)
> CDate datetime
> SCDate datetime
>
> The problem is that when I use the following query like.
>
> select count(*) from medicalhistory
>
> It is continously running and doesn't give me any result, so I get the
> count
> from the following query
>
> select rowcnt from sysindexes where id = object_id('medicalhistory')
>
> 12819530
>
> There is no index in the above table and I also use the following command
> for consistency error.
>
> DBCC Checktable ('medicalhistory')
>
> Result:-
> DBCC results for 'medicalhistory'.
> There are 12819530 rows in 218027 pages for object 'medicalhistory'.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
>
> Even when I use this command like
>
> select * from medicalhistory where ID = 523662
>
> It is continously running and doesn't give me any result
>
> Can any one give me his or her expert idea like this is the table
> corruption
> or what the problem is ?
>
> What I have to do now?
>
> Thanks in advance.
>
>
>
>
>
>


.

Relevant Pages

  • Re: Table problem ?
    ... > UPDATE STATISTICS ... >>I have one table which name is medicalhistory which structure is as ... >> DBCC results for 'medicalhistory'. ... If DBCC printed error messages, ...
    (microsoft.public.sqlserver.clients)
  • table corruption I think so !
    ... I have one table which name is medicalhistory which structure is as follows. ... The problem is that when I use the following query like. ... DBCC results for 'medicalhistory'. ... If DBCC printed error messages, ...
    (microsoft.public.sqlserver.clients)
  • Re: table corruption I think so !
    ... The DBCC output shows that table is clean. ... >I have one table which name is medicalhistory which structure is as ... > There is no index in the above table and I also use the following command ... If DBCC printed error messages, ...
    (microsoft.public.sqlserver.clients)
  • Table problem ?
    ... I have one table which name is medicalhistory which structure is as follows. ... TId int ... CDate datetime ... DBCC results for 'medicalhistory'. ...
    (microsoft.public.sqlserver.clients)
  • Re: Advice Please
    ... DBCC doesn't exist with ASA - it's dbvalid. ...
    (comp.databases.sybase)
Loading