There is an interesting and useful new feature in SQL 2005 where it takes all queries that execute and don't find an optimal index...and records the information. You can use this information to generate indexes and speed up your performance.
Read More