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