I recently came across the following whitepaper for configuring SQL Server to get the best performance from it when used in a SharePoint environment.
Download it from here
Or view it from here
Lots of good information in it and well worth keeping to refer to when building SharePoint environments 🙂
