A primer on SQL Server database files

A high-performance database system is the product of good database design, both physical and logical. To get the most out of your database system design, you must have a solid understanding of the files the database server uses, and the types of hardware you should deploy these files on.