SQL Server optimization

This is a very thorough article on ways to speed up a SQL database by Matt Perdeck Speeding up database access – Part 1: Missing indexes