Are you migrating to SQL Server from postgreSQL, or the other way around?

What exactly is wrong with having a NULL date if the date is actually unknown or does not apply?

It is a good design practice to not allow a required column...

Brian,

You are posting criticisms of Red-Gate on a site that they own, and I don’t see any effort to remove your posts, so the censorship doesn’t seem too oppressive to...

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...