Ray tackles the huge topic of SQL tips, his first installment is a good one. http://blog.discountasp.net/microsoft-sql-server-tips-series-one-data-and-log-file/
