- Above all, Install SQL server with much fun and devotion.
- Preconfigure TEMPDB, not leaving defaults, for better throughput and performance.
- You shall protect the data and make back-ups as if it was the Chosen one.
- Test, Test and Test the restoring of data in order to anticipate on future disasters, this might be your salvation.
- Thou shallt install SQL server updates and patches after testing.
- Carve traceflags into stone, they can relieve the pressure and pain.
- Spend time setting up appropriate maintenance as if it were fitness to your body. It will keep your database healthy after you install SQL server.
- Make adjustments to default growth. Let databases grow by chunks wisely chosen in megabytes.
- Tailor your degree of parallellism and Cost treshold for parallellism.
- As an addendum, consider using volume maintenance tasks, lock pages in memory.
Menu
