Try these four steps to make SQL queries run faster:
Expand server memory
Partition tables
Remove outer joins
Reorganize joins to filter out the most records first
Ensure that joins hit indexes
Remove wildcards in the column list