We moved to a paid posting service. They're supposed to backfill some jobs. I'll check on that.

I'd talk to a few recruiters. They don't cost you anything and they might...

There's a DTS 2000 runtime for SQL Server 2005 so you can run them. Otherwise, rewrite them in SSIS.

#1 above doesn't matter. It's in his example. You'd just put phone number in your query. SQL will find the field.

Look for the max date for which you have things...

If you're in the US, let me know where. I can recommend a few people as well. Or you can work remotely with Colin.

However you should hire someone. There's too...

A rebuild of the indexes usually requires 1.5x the space of the largest table for data, depending on fragmentation it might require more in the log. That's likely what is.

Andras...

It's not that old! Heck, it's just one version back, still supported for

select datediff(d, getdate(), '4/8/08') *

* date subject to change based on the actual RTM date for Katmai...

Yikes, haven't worried about stdin or stdout in years.

I like being a specialist. It's been good to me (and profitable), but it certainly has helped to be a generalist overall...

There are definitely some strange behaviors in 8.0 mode. Andy Warren reported a few issues with some 9.0 features "bleeding" through into the dbs when in 8.0 mode. I...

Very strange.

Are you sure the data is the same? How have you verified? I don't mean to be difficult, but "test" environments often are shared and I've seen people change...

You'd think they'd make it easy. I had to double check, too 😉

Log size is a good indication because this data is what's being sent by database mirroring.

However it's sent as it's written to the primary log, so if you have...

TJ,

Old Hand is a rating based on posts, not the name. The name is above that in bold, so it's Adam you were responding to.

Second, RAM isn't related to...

The SQL Server name needs to match the Windows server name.

Sp_dropserver

go

sp_addserver (new name), local

will fix the naming. For clients, they'll need to repoint to the new name unless they are...

You definitely have to get along and share information to get things to work smoothly.

But I'll disagree with you. Social activities are a way to do team building, not just...

You need to install the SQL Server services. If this is 2005, then you need to install the Developer Edition, Workgroup edition, or Express edition. You will have a SQL...