SQL Server offers three recovery models: full, simple and bulk-logged. Here is when to select each one, based on how much data loss you can accept.
SQL SERVER – MS TechNet : Storage Top 10 Best Practices
My pick of the Storage Top 10 Best Practices from MS TechNet: know your IO, keep designs simple, put logs on RAID 1+0, isolate logs from data and plan TEMPDB.
SQLAuthority News – Author Visit – MIS2007 Part II – Database Raid Discussion
At MIS2007 we had a database RAID discussion: RAID 5 or RAID 10 for databases from 5 GB to 5 TB. Almost everyone picked RAID 10, even though it costs more.
SQL SERVER – FIX : ERROR 1101 : Could not allocate a new page for database because of insufficient disk space in filegroup
Error 1101, could not allocate a new page because of insufficient disk space in filegroup. Free up hard disk space and turn on AUTOGROW for the filegroups.
SQL SERVER – Raid Configuration – RAID 10
Which RAID do I use for my SQL Servers? RAID 10. It gives great read and write performance, while RAID 5 pays a write penalty for parity.
SQL SERVER – TempDB is Full. Move TempDB from one drive to another drive.
TempDB is full and you see Event ID 17052 for the tempdb log? Here is what to check first and how to move TempDB from one drive to another.