Take a look this post. Performance varies depends on how the query is written (interesting though). http://www.sqlservercentral.com/Forums/Topic476887-146-1.aspx

Have you run update statistics after the migration?

correction:

--> More frequent log backup helps to reduce the log size.

should be “More frequent log backup helps to free log space to be reused. It will not shrink...

Seems need to contact the vendor. Whether the application support data mirroring and how.

is the log size increase due to the less frequent log backup's?? --> More frequent log backup helps to reduce the log size.

Do you have bulk insert activities, or big...

Hugo’s link is more recent. So it can be a proof for the answer. The most important thing is MS supported.

I am afraid of doing so in a...

Take a look your SQL server configuration. This recent KB may help:

http://support.microsoft.com/kb/329204

Take a look this link. Maxdop may be an option. Test it first.

http://www.sqlservercentral.com/articles/Configuring/managingmaxdegreeofparallelism/1029/

I doubt about the answer. Here is the link for discussion:

http://www.microsoft.com/sql/downloads/trial-system-requirements.mspx

“Upgrading and Uninstalling the Trial Software”

Enterprise Manager? SQL2000 or SQL2005?

Name + profession can take max 154?

[Name] NVARCHAR(50) --> 50 X 2 + 2 = 102

Ref BOL: "nchar and nvarchar (Transact-SQL)"

The storage size, in bytes, is two...

You may use Sysinternals Suite to find out which process is holding the backup file. Take a look handle or Process Explorer.

http://technet.microsoft.com/en-us/sysinternals/0e18b180-9b7a-4c49-8120-c47c5a693683.aspx

I used PowerDesigner before (older version for SQL2000). There is a reverse engineering feature which allows you to run against an existing database and produce the diagram/report. The...

You can download & install Performance Dashboard Reports for SQL2005. SQL2008 CTP has it built in already. There is a backup and restore events report, and it will...

Thank you Grant. MS responded to use SQL Server 2008 Resource Governor as an answer yesterday.

As bitbucket said “learning more than just the QOD answer”. I do see quite a few questions give me better understanding of specific area from both answers, no matter...