How or could this solution work on Log Shipping 1500dbs when the 2nd server is NOT on the domain? I have most of this solution working but how could I...

How about if there were 8 internal 1TB hard-drives and 4 External 2TB hard-drives, any recommendation for high performance configuration? Thanks.

Reggie

Could I see a performance change with 2000 and 2008 if they are configured as

2000 has Windows2003 Enterprise with 8GB RAM

2008R2 has Windows2008 R2 Enterprise with 8GB RAM

Could 2008 performace...

Yea. All the datatypes in the joins are int.

Could it be because of having over 50mil records in one table and over 80mil in a 2nd table and neither are...

I removed the Loop hint and it seem to make the performance worse than what it was before the move.

It degraded tremendously with the loop hint removed.

OK After further testing I still have one query that still has increased its performance with the upgrade. I've studied the Exec plan and see that there is a scan...

Thanks for all the input.

After running update statics on 5 of the must active tables the queries are running much better, as if it was still in the SQL...

Can anyone add additional insight on steps for moving a single SQL Server instance into a clustered environment. Thanks.

Regards,

Reggie