We've just installed a new SQL server. It's running 64bit Windows 2008 Server Std and SQL 2008. It will be used exclusively for our SQL application. It has 12gb ram and the database is around 5gb.
What configuration changes would you advise to SQL to get the best out of the system, or should I leave the defaults. In particular should I enable the AWE?