Re: Something for newbies (like myself) to consider

From: Ken Briscoe (youcant_at_sendmespam.invalid)
Date: 04/02/04


Date: Thu, 1 Apr 2004 21:18:12 -0500


"kpg" <kpgraci@rtcpantaloononline.com> wrote in message
news:eFdOq$EGEHA.3372@TK2MSFTNGP09.phx.gbl...
> How my day is going.

<snip>

You lose the weird happenings game.

Today, my SQL server decided it didn't want to process the ORDER BY clause.
Yes, you read that right. A simple select query, which would return under
1000 records normally takes a second or two, tops. Throw in the order by
clause, and it took upwards of 10 minutes to process. Needless to say, this
put a damper on my Crystal Report writing. Never got to the bottom of it,
but I stopped and restarted the SQL service, and now it's running well
again. However, I'm not holding my breath that all will be well tomorrow...

--
KB  -  MCNGP "silent thug" #26
first initial last name AT hotmail DOT com
---
Virus? In the computer? Are you serious?
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.619 / Virus Database: 398 - Release Date: 3/10/2004


Relevant Pages

  • Re: And copyright in Europe goes to..... 70 years
    ... one that is codified by law and by international treaty. ... Umm, Article I, Section 8, Clause 8: ...
    (rec.music.classical.recordings)
  • Re: And copyright in Europe goes to..... 70 years
    ... The concept of intellectual property is one that is codified by law and by international treaty. ... Umm, Article I, Section 8, Clause 8: ...
    (rec.music.classical.recordings)
  • Re: Reading a file...
    ... all of your advices and this is the result: ... snip long extended code ... ... clause, arrange to have the short clause first. ...
    (comp.lang.c)
  • Re: Something for newbies (like myself) to consider
    ... "Ken Briscoe" wrote in ... > You lose the weird happenings game. ... > in the order by clause, and it took upwards of 10 minutes to process. ... this put a damper on my Crystal Report writing. ...
    (microsoft.public.cert.exam.mcse)
  • Re: online C programming test
    ... Peter Pichler wrote: ... > there a clause in GPL that I missed that says that the source must be ...
    (comp.lang.c)