Also could be that the optimizer fixes are enabled/disabled on one of the databases and not the others. That would certainly lead to differences, especially if the query is already...

Ah, a restore won't move the logins. You'll need to script those out on the original server and move them over.

The missing indexes are, at best, suggestions. Be very cautious in simply implementing them.

As to the connections, step through it as granular as possible. What login do...

More than one drive and more than one drive controller would be better. SQL Server is IO intensive.

Part of the upgrade process should be testing. You should be moving the database or databases in question in a non-production environment where you can validate whether or not your...

And change the data types so that you're storing date and time as date and time. Same thing goes for any other data type.

Not a clue how to address your specific issue, but, one HUGE point.

The GUI for Profiler has a different memory management mechanism within SQL Server than the server-side...

You can only get that information if you are gathering query metrics in some fashion. Since you're posting in a 2008 forum, the general method for this is to use...

When thinking about performance of the database, two things should drive your processes. First, you only get one clustered index and it defines data storage. Therefore, the most common path...