Here is a very good article on how you can Optimizing SQL Server for SharePoint 2010. http://mscerts.programming4.us/sharepoint/optimizing%20sql%20server%20for%20sharepoint%202010%20%28part%204%29%20-%20pre-creating%20your%20content%20databases.aspx

It lists how you should preset your databases.

Advertisements