Anders brings up a good point, and one I'm addressing now. What happens if Steve leaves (I'm not planning on it).

Everyone should have...

Anders,

I guess I'd disagree on this. You should be allowed to go to court, but the film and record of the camera is evidence. I think you're responsible for your...

The summary is that if you have un-authenticated users, meaning not in your AD forest, you need a processor license. If you have employees or partners, with AD accounts, you...

Yep, steve_smith, of (steve) Smith and Jones fame, hit it. It should run a little faster if that field is indexed and it's used.

TheSQLGuru has the best reason. The old syntax will get dropped.

I think the inner join syntax reduces mistakes and it's easier to read, but that's personal preference. I never had...

Actually in SQL Server, a system backup of the host Windows system wouldn't get the databases. The files would be locked, so without a database backup plan by the DBA,...

Are you looking at the right dates? Meaning are there multiple dates in the table and the one in the WHERE clause is the right one?

It worked for me as...

Sounds more like you want some sort of SSIS package. The header row with rowcount will be slightly tricky. You need this info first, so it's probably two queries you're...

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