there were a few times i changed the sort order of indexes to make things a bit faster. when you can't spend $6000 on extra storage because all the internal hard drive bays are full but you need to optimize I/O performance you look at every little thing.

i'm waiting for the SSD server drives to get cheaper to try them out by putting tempdb on them