Re: Table problem ?

EXEC sp_updatestats (is it ample?)

Thanks



"Jens Süßmeyer" <Jens@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:uglT$4SQFHA.2736@xxxxxxxxxxxxxxxxxxxxxxx
> 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)