We have a poorly performing SQL 2005 standard server. So, I created a new server and want to move the databases from the old server to the new one. Please answer both of the following questions:
1. How should I proceed and what are the risks?
2. What settings should I change from the default for best operation?
Please keep in mind that I know next to nothing about SQL.