I came across this great article by Jon Galloway on why you should not use SELECT * style queries.

Are SELECT * queries bad? Sure, everyone know that. But, why?
It’s returning too much data, right?

That’s the common answer, but I don’t think it’s the right one. If you’re working with a reasonably normalized database, the actual network traffic difference is pretty small.