Brian,

I didn't see anything in Simon Facer's post to qualify as "anti-U.S. xenophobia", unless that means someone who disagrees with you.

If you are trying to get the message out that...

Bob didn’t make it clear in his post that he had a commercial interest in what he posted, he cross-posted to about 8 forums, and it wasn’t clear to me...

That’s not a convincing argument.

Being unable to think of an alternative explanation is not proof of the explanation you can think of.

CalcDate is a table valued function, so I don't think you can use it there.

It might also help to add a WHERE clause if the majority of the rows don't need to be updated because the Current_County is already correct.

UPDATE Standard2
SET
 Current_County = ZipMkt06.County2
FROM
 Standard2
 INNER JOIN
 zipmkt06
 ON standard2.patzip = zipmkt06.zip
where
 Standard2.Current_County is...

You should run transaction log backups a lot more often.  We do them at least every 15 min 24x7, and sometimes as often as every 5 minutes on really active...

Uptime.exe Tool Allows You to Estimate Server Availability with Windows NT 4.0 SP4 or Higher:

http://support.microsoft.com/kb/232243

Quite a coincidence that you have the same name as a product manager for Quest LiteSpeed, a competing product.

http://qlist1.quest.com/read/messages?id=17779

Quite a coincidence that you have the same name as a product manager for Quest LiteSpeed, a competing product.

http://qlist1.quest.com/read/messages?id=17779

Do people really pay attention to certifications when they are hiring?

I never give certifications any consideration when I am looking at candidates resumes.

Sounds like an easy problem to solve:  Don't buy their software if you don't like the license terms.

You may want to read this thread on the whole subject of identity primary keys vs. natural keys.  As you might be able to see from the debate on this...

The storage size of the decimal(19,0) is 9 bytes vs. 8 bytes for bigint, so it would save some storage space, but you wouldn't save that much space unless the...

Here are a couple of way to do it:

select
 M1 = right(1000000+MyNumber,4) ,
 M2 = right('0000'+convert(varchar(20),MyNumber),4)
from
 (
 select MyNumber=1 union all
 select 10 union all
 select 44 union all
 select 7777 union all
 select 9999 union all
 select 111
 ) a

Results:

M1   M2   
---- ---- 
0001...

One thing you might try, if you haven't already, is using Profiler to capture the query workload to a table, and then use the Index Tuning Wizard to see if...