Re: SELECT COUNT(*) returning wrong value

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Adam Machanic (amachanic_at_hotmail._removetoemail_.com)
Date: 08/27/04 

Date: Fri, 27 Aug 2004 15:16:40 -0400

"Stan Rozendal" <StanRozendal@discussions.microsoft.com> wrote in message
news:0958D56A-3E6D-4CF2-BD9D-FF8C28F46AA7@microsoft.com...
> Thanks Adam...changing 'max degree of parallelism' from 0 to 1 resolved
the
> problem. I will now investigate whether this is viable from the
performance
> perspective.

    I'm glad this was finally resolved; I'm especially happy it wasn't data
corruption, as that would lessen my trust in SQL Server's abilities to keep
solid integrity.

    As for the issue itself, according to the KB article there is a hotfix.
So you should give PSS a call if you like to sit on the phone on hold for an
hour :-)

Relevant Pages

  • RE: Make table Query not "updating" 1 field
    ... Speaking of corruption, if it is that: ... When I change the make-table querry into a select querry the LastUpdate ... There ar no lines - it is simply a cut & past from the SQL view of the querry. ... Does TCURRENT show up then? ...
    (microsoft.public.access.queries)
  • Re: SPS WebPart and access to databases. - Error
    ... under the minimal trust asp.net doesn't fully trust sql server ... You need to add the sql client trust connection from ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: Extent is marked allocated in the GAM (Server: Msg 8905)
    ... It also seems that the corruption happened a while ago ... when you get to the SQL ... "ktf" wrote in message ... stayed there even doing dbcc with repair option on. ...
    (microsoft.public.sqlserver.server)
  • Re: Transferring Database to SQL Server
    ... It is in VFP. ... SQL ... is a hodgepodge language though. ... Some people have complained about FoxPro data corruption, ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Standalone IIS server access to sql in Domain
    ... There is no way to "trust" a domain from a non-domain machine - the only workaround is to replicate the account used on both ends. ... That means you need an account on IIS and the same account on the sql server machine. ...
    (microsoft.public.dotnet.framework.aspnet.security)