Re: Table problem ?

Hi

select * from medicalhistory where ID = 523662
OPTION (MAXDOP 1)
GO

Whilst this is running, check wit ha another connection sp_who2 for blocking
-
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@xxxxxxxxxxxx

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Joh" <joh@xxxxxxxxxxxx> wrote in message
news:uTlHvaTQFHA.244@xxxxxxxxxxxxxxxxxxxxxxx
> Are you sure this is not the table corruption problem ?
>
>
> "Joh" <joh@xxxxxxxxxxxx> wrote in message
> news:uoKtWZTQFHA.2876@xxxxxxxxxxxxxxxxxxxxxxx
>> sorry Man... same issue !
>>
>> I think there is some big problem in this table.
>>
>>
>> "Joh" <joh@xxxxxxxxxxxx> wrote in message
>> news:OhRS7VTQFHA.648@xxxxxxxxxxxxxxxxxxxxxxx
>> > Lemme check and update you !
>> >
>> > "Jens Süßmeyer" <Jens@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
>> > wrote
>> in
>> > message news:OGaAOUTQFHA.1472@xxxxxxxxxxxxxxxxxxxxxxx
>> > > Last shot for me is:
>> > >
>> > > DBCC DBREINDEX (<name>, '', 0)
>> > >
>> > > Could be an corrupt index there.
>> > >
>> > > Jens.
>> > >
>> > >
>> > >
>> > > "Joh" <joh@xxxxxxxxxxxx> schrieb im Newsbeitrag
>> > > news:OOpwTOTQFHA.3288@xxxxxxxxxxxxxxxxxxxxxxx
>> > > > no effects, still same problem .... any other tips?
>> > > >
>> > > > Thanks in advance.
>> > > >
>> > > > "Jens Süßmeyer" <Jens@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
>> wrote
>> > > > in
>> > > > message news:usL5mLTQFHA.3544@xxxxxxxxxxxxxxxxxxxxxxx
>> > > >> That does it for all user tables in the databases.
>> > > >>
>> > > >> HTH, Jens Süßmeyer.
>> > > >>
>> > > >>
>> > > >> "Joh" <joh@xxxxxxxxxxxx> schrieb im Newsbeitrag
>> > > >> news:eeeiLETQFHA.1932@xxxxxxxxxxxxxxxxxxxxxxx
>> > > >> > 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: San Performace with SQl Server
    ... >> Mike Epprecht, Microsoft SQL Server MVP ... >> Zurich, Switzerland ... >> MVP Program: http://www.microsoft.com/mvp ... >> Blog: http://www.msmvps.com/epprecht/ ...
    (microsoft.public.sqlserver.clustering)
  • Re: Writing custom odbc driver.
    ... >> Mike Epprecht, Microsoft SQL Server MVP ... >> Zurich, Switzerland ... >> MVP Program: http://www.microsoft.com/mvp ... >>> I am trying to write a custom odbc driver for one of my application. ...
    (microsoft.public.sqlserver.odbc)
  • Re: Image save into folder
    ... Mike Epprecht, Microsoft SQL Server MVP ... >> Mike Epprecht, Microsoft SQL Server MVP ... >> Zurich, Switzerland ... >> MVP Program: http://www.microsoft.com/mvp ...
    (microsoft.public.sqlserver.clients)
  • Re: SQL 2005 - beta period expired??
    ... >> Mike Epprecht, Microsoft SQL Server MVP ... >> Zurich, Switzerland ... >> MVP Program: http://www.microsoft.com/mvp ...
    (microsoft.public.sqlserver.setup)
  • Re: SP4 Reliase Bug
    ... Mike Epprecht, Microsoft SQL Server MVP ... Zurich, Switzerland ... MVP Program: http://www.microsoft.com/mvp ...
    (microsoft.public.sqlserver.clients)