I've already seen 2 Jane's Addiction songs mentioned (and I had my wedding party introduced to Up The Beach), but Three Days gets me fired up every time.
http://www.youtube.com/watch?v=SmvG2GZ3S7o
One, by Metallica has also been mentioned and I would suggest it is even more effective while watching the video.
http://www.youtube.com/watch?v=WM8bTdBs-cw
Same goes for Forty Six & 2 by Tool.