I do agree with Jeff. I try to avoid outer joins where it makes sense, but definitely test both ways and be sure you understand the difference between the ON...

Also, in addition to Jeff and Jim, the index need not be clustered.

Are you sure the agent service is running? You can create jobs without it being started.

I'd agree with Joe, concerns would be sp_oacreate, not the driver. Drivers do flake, leak memory, etc., but in the past for me that's resulted in not being able to...

You need to specify the fields here from the first table and join in the second table for each value.

So

select

a.pkcol

, b.val 'fever'

...

LOL, dropping the server is good.

We've tended to use multiple people to move servers now that most of us are past the 20 something stage. Felt embaressed to use...

Thanks and I'll have to look around. AFAIK you can't manage processes inside SQL Server (yet). The resource governer is SS2K8 is very exciting for me. I've been asking for...

Wow, more responses than I expected.

I think privacy is important. Maybe the definition of privacy needs to be changed and maybe our idea of what to expect should be altered,...

Have you looked at Reporting Services? It's free and easy.

If you are scripting, and you have some code, I used to use Active Reports and it worked great.

Agree with Bob. Keep the RI, prevents errors with triggers as code changes.

Tend to agree with Erik's advice myself.

I will say that some of the research from MS on very large DBs has been splitting off entire objects (data + indexes) into...

Good point. I hadn't thought about them trying to compete by removing Google's advantage, but it makes sense.

If there are alpha codes, wouldn't "< '9999'" work? Alphas should order above that. Might help it slightly,

I believe it's distributor, publisher, subscriber order.

Some of this changes in SQL Server 2008 with resource governers that can limit work in other areas, but I don't think you can specify affinity for a specific process...