Re: 100% CPU Util on Simple Update Query

From: Joel H (JoelH_at_discussions.microsoft.com)
Date: 02/09/05 

Date: Wed, 9 Feb 2005 07:59:06 -0800

I actually got it to fail on the statement shown. Only names of the table and
field are changed. I was writing into a char 25 field.
There is no WHERE clause. Even in the original statement, all of the work is
done on one row at a time. I got to that statement by trying to narrow the
problem.
Could I be overwriting something without an error message.?
On the production machine, I was able to get the whole SP to run, but it
took about 45 minutes instead of a couple of seconds. I suspect an indexing
problem, but as you can see, I don't know what else to fix.
Thanks

"Jesse Beveridge" wrote:

> What is the actual statement? Is there a where clause on it?
>

Relevant Pages

  • Re: Beth HaWaadh Permits Eating of Kitniyoth by all Jews in Israel During Pesah
    ... pasuq, ask me why I do not think writing (not even pronouncing, mind ... says this pasuq is a negative commandment. ... Rambam himself gives an example of what the words mean, ... I never wondered why you fail to address me as a talmid chacham. ...
    (soc.culture.jewish.moderated)
  • Re: fwrite() misses writing a byte
    ... binary files which is just some marshalled data. ... I presume that Datais a single byte (type char, signed char, or ... then you're just writing the first byte ... meaningful error message. ...
    (comp.lang.c)
  • Re: Access violation in free()
    ... Better: char *CopyString ... writing. ... looking for a new word processor. ...
    (comp.lang.c)
  • Re: Is there a standard way to write an 8 bit byte?
    ... > I would like to write completely platform-independent code if at all ... char is only guaranteed to be at least 8 bits. ... writing a char into a file in binary mode would result in 9 bits being ... There is no cast iron guarantee in the C standard that this will produce the ...
    (comp.lang.c)
  • Re: generics and arrays and multi-class collections
    ... with the variable name, that is, a pointer is not char* p, but char ... you get pretty tired of writing.field. ... And then there's the lack of nice basic string manipulation. ... Everything is so bloody low-level. ...
    (comp.lang.java.programmer)