Re: update VFP9 & update SQLServer 2005

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I think it is an error to depend on the execution order. As I understand it,
a SQL statement should be considered as operating all-at-once, and no
assumptions can be made about the sequence of execution of its parts.

I think it's a dangerous idea to assume parallelism by default. Anyway,
I don't control technology in the States. :)

--
.~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org
/ v \ Simplicity is Beauty! May the Force and Farce be with you!
/( _ )\ (Ubuntu 6.10) Linux 2.6.19
^ ^ 13:37:01 up 6 days 16:52 1 user load average: 1.00 1.02 1.00
news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk
.

Relevant Pages

  • Re: accept ... from time
    ... I want to measure the execution time of a sql statement. ... DISPLAY "EXECUTION lasted from" START-TIME ... two such statements in sequence to see what the latent delay is and as ...
    (comp.lang.cobol)
  • Re: CBO & different execution plans
    ... query, ... Oracle 10g generates a non-performant execution plan. ... rows being returned by the SQL statement. ...
    (comp.databases.oracle.server)
  • Re: poll(2) on a pipe fd
    ... I don't know how I deserved this offense by simply stating "I agree with you, but not because your proof is correct -- because, independently, I find that proof ungrounded in standards". ... each function call is C is by definition 'a side effect' and it is also a sequence point. ... At certain specified points in the execution sequence called ... all expressions are evaluated as specified by ...
    (comp.os.linux.development.apps)
  • Re: poll(2) on a pipe fd
    ... the broken system ... and another process executes the command sequence ... At certain specified points in the execution sequence called ... The least requirements on a conforming implementation are: ...
    (comp.os.linux.development.apps)
  • Re: CBO & different execution plans
    ... a SQL statement in a packaged application that was taking excessively ... long to execute - roughly 3.4 seconds per execution and the packaged ... The problem in this case had to do with Oracle picking ... Providing a hint to Oracle to use ...
    (comp.databases.oracle.server)