Did you try using the "OPTION (MAXDOP 2)" on the 4-CPU server ?

Maybe this query perform better with 2 CPUs only.

I have the following situation in here:

the developers use...

Exactly.

As I said, I use this approach due to a disk space limitation.

I don't think that this is the best

solution. Far from that...

I was just saying that...

quote:

So, when there can be more than one, who decides which C:\ drive to take?

Frank,

SQL Server uses the C: drive of the active node on this case. It works that...

Sorry for the long post, but the original writer apparently removed this page from his web site...

It's an Oracle perspective from a Sybase DBA,

and I think that it fits as...

Not yet.

I will.

Actually no.

Take the following example:

SELECT REPLACE ('ABCDE', 'BD', 'CE')

The result will be 'ABCDE', because the 'BD' string doesn't exists in the 'ABCDE' string.

If you use TRANSLATE:

SELECT TRANSLATE ('ABCDE', 'BD', 'CE')

It...