Viewing 6 posts - 1 through 6 (of 6 total)
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...
June 25, 2003 at 5:30 am
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...
June 5, 2003 at 9:00 am
So, when there can be more than one, who decides which C:\ drive to take?
SQL Server uses the C: drive of the active node on this case. It works that...
June 5, 2003 at 8:31 am
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...
October 21, 2002 at 9:02 am
January 3, 2002 at 6:16 am
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')
January 3, 2002 at 5:06 am