Re: Table problem ?

Hi

It forces the query to only execute on 1 processor instead of multiple
processors if present.

Search for "Query Parallelism Bugs" on Google.

Regards
--------------------------------
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:%23uKmN9bQFHA.648@xxxxxxxxxxxxxxxxxxxxxxx
> what does it means OPTION (MAXDOP 1)?
>
> "Mike Epprecht (SQL MVP)" <mike@xxxxxxxxxxxx> wrote in message
> news:uYXr7sZQFHA.1396@xxxxxxxxxxxxxxxxxxxxxxx
>> 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