Re: Table problem ?

Tech-Archive recommends: Fix windows errors by optimizing your registry

Okie thanks..

"Mike Epprecht (SQL MVP)" <mike@xxxxxxxxxxxx> wrote in message
news:#YY2yEcQFHA.3336@xxxxxxxxxxxxxxxxxxxxxxx
> 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

  • Re: Best Config for 4GB Ram SERVER
    ... Mike Epprecht, Microsoft SQL Server MVP ... >> Mike Epprecht, Microsoft SQL Server MVP ... >> Zurich, Switzerland ...
    (microsoft.public.sqlserver.setup)
  • Re: Transact sql to remove space
    ... > Mike Epprecht, Microsoft SQL Server MVP ... > Zurich, Switzerland ...
    (microsoft.public.sqlserver.programming)
  • Re: SP4 Reliase Bug
    ... Mike Epprecht, Microsoft SQL Server MVP ... Zurich, Switzerland ... MVP Program: http://www.microsoft.com/mvp ...
    (microsoft.public.sqlserver.clients)
  • Re: Active/Passive in front of a SAN--best practices
    ... Mike Epprecht, Microsoft SQL Server MVP ... Zurich, Switzerland ...
    (microsoft.public.sqlserver.clustering)
  • Re: Connection
    ... Mike Epprecht, Microsoft SQL Server MVP ... Zurich, Switzerland ...
    (microsoft.public.sqlserver.connect)