You need to pick up a book on SQL server performance tuning.

Also there are several articles here on sql server central, also check out blogs etc.

Books online is a great resource as well.