datetime tune date into pad dynamic cursor money percent sp job isnumeric while over update
SQL Server Scripts SQL 2005 SQL 2008 Articles
How to configure the hard disks for optimal performance?

Disk is the slowest part of the computer. Physical movements involved two ways: disk read/write head positioning to a track and spinning of the disk. Therefore it is crucial to have sufficient high-performance disk resources and configure them for optimal performance. RAM memory caching at different levels is helpful to overcome the disk sluggishness.

The following SQL Server disk drive configuration is reliable, high performance and relatively low cost:

Drive C 60 GB RAID 1 mirrored hard drive: operating system / SQL Server software

Drive D 60 GB RAID 1 mirrored hard drive: temporary database (tempdb) data file

Drive E 300 GB RAID 5 hard drive array: application database data files

Drive F 60 GB RAID 1 mirrored hard drive: transaction logs

Drive G 120 GB RAID 0 hard drive: staging files - feeds, disk-to-disk-to-tape backups, etc.
    Note: RAID 0 is not redundant

For additional performance gain place tempdb log on a dedicated RAID 1 drive.

Related articles:

Hard Drive Configurations for SQL Server

Storage Top 10 Best Practices

Deciding the best disk configuration for your SQL Server

About hard drive configuration for SQL Server

SAN Storage Best Practices for SQL Server

Deploying SQL Server 2005 with SAN #1

SQL Server 2005 Configuration Blog #2.doc

Deploying SQL Server 2005 with SAN #3

SQL Server Script Resources for IT Professionals


Exam Prep 70-461
Exam 70-461