Which rock song do you think has the best saxophone solo? Think in terms of best sound quality, best recording quality, and best instrumental performance. If you had to provide a single example of saxophone in a rock and roll song demonstrating how a saxophone would be used in a rock mix, which artist, musician, song and recording would you select?
Such a tough question! Lisa Simpson and Bleeding Gums Murphy hold a place near and dear to my heart. I can't seem to find any good recordings of their work though =)
Seriously though, Your Latest Trick by The Dire Straits is great. But when I think of saxophone solos, I think of Yackity Sax by Boots Randolf and Jungleland by Clarence Clemens. Clarence Clemens was the first sax musician I saw where you could feel the emotion and fire. His passion, energy, enthusiasm...they are unmatched and are truly representative of how I think the sax should be used in a rock mix.
Having said that, Yackity Sax is a revolutionary piece that is (for me) synonymous with the sax. It's the only thing that I can think of that could top even Clarence Clemens. When I first read the question, Clarence came immediately to mind, but to be honest, even he is edged out by Yackity Sax!
It's disappointing how underutilized the sax is in modern rock. It seems, with rare exceptions, that if the music doesn't fit a formula, it's not accepted. The sax has not been a part of the accepted formula, and has been neglected.
Edit: I didn't want to spoil my answer by reading what others posted first, but after reviewing the thread, I realized I completely neglected David Sanbourn. In my book, David Sanborn's alto sax solo in "Let Me Be Your Pirate" by Nena should have been mentioned by me above, and although not the best of the best, is a strong honorable mention!