Useful seeing it listed out like that.

#10 - Whack a Mole. I Like to do something similar but add to the equation total time of queries. Saving 2 seconds off a 3 second query that runs a thousand times a day is better than 10 seconds off a 15 second query that runs only two or three times a day.