First off, thanks for all the replies.

The row count is somewhere near 5,000,000-7,000,000.  About 100,000 total will be updated daily.  The LEN(RTRIM(LTRIM(ERR))) > 0 will be evaluated probably about 5,000...

If I allow for nulls it will slow down my updates and editing. 

If there are any nulls in a table then an update is done as a delete-then-insert.

If there...

So really I could reduce it to:

RTRIM(ERR)>''

(since > is faster than !=)

The column does not allow for nulls.

I tried that and it didn't speed anything up.  The run times are the same and the query plan say that queries take equal resources.

It does simplify my query, but...

Sounds like he did most of the level 1 mods to it.  Anyone that has a small sportcar from the 70s will either turn into an amateur mechanic or put...

What year is your 914?  Have you done any racing mods to it yet?  I know the aluminum flywheel is a common upgrade for the 914.  Any chance you have...

Not sure why you think that your response was 'nastily'.  I wasn't trying to tell everyone it was a hardware problem, I just wanted everyone to look 'outside the box'...

Does the system have a 'nice' shutdown or is it simply turning itsself off?

I would look into the internal temperature of the system or another nonsoftware problem.  Maybe you have...

I can't believe that no one has suggested this, but is there any maintenance(vacuumming, trash removal) people scheduled to do anything during those times?

It's possible that a maid is...

Working toward getting my pro-card being a male prostitute.(ha ha)  (A nod to Saturday Night Live - Fred Garvin played by Dan Akroid)

Come on, I can't believe that this article actually DEFENDS Win98!  I admit that 98se was a better product as was ME, but it was NOT my any stretch of the...

I have not owned any of the 'new' dodges.  My sister has a durango and really likes it.  It seems nice, but there are things in it that don't make...

I have just heard nothing but bad things from friends who have owned them.  I won't own anything but Japanese from now on.  I have a 2001 Nissan Pathfinder that...

Nevermind.  I read the 'lessons learned' link.  Cadillacs are still junk built for the clueless consumer.