I feel for you. We run several SharePoint sites and it has been more difficult to find definitive answers regarding SQL database configuration, troubleshooting, etc. than with non-SharePoint databases.
That said, here is an article from Kimberly Tripp I refer back to from time to time: