In my experience drinking hasn't been conducive to being a good programming/problem solver. I don't have the mental stamina to finish a program when I'm hungover.
Agreed. I find even a beer or two throws me off. However, when I need to write emails or some more social, less technical thing, a couple beers makes me way more productive. I think because I tend to waffle on verbiage and think things like, "no, that sounds condescending and I don't mean it to be, backspace" I find a little alcohol brings the "fuck it, send" threshold close enough to be productive at something I'm kind of bad at sober.
Reminds me of this talk about creativity by John Cleese[1]. The tl;dw is creativity is about getting into an open, uninhibited state of mind where new or risky ideas flow freely. Then getting into a closed, more focused state that allows you to implement the idea without getting distracted. Being able to switch between the two modes is key to creative problem solving.
I guess for me, alcohol promotes the open mode, but pretty completely wrecks the closed mode.
Hungover yeah not good, but I find a beer or two can give you a different perspective on something that's exactly what you need sometimes. Like how you solve problems in your sleep or in the shower, sometimes just saying 'screw it' and doing something sloppily gives you the clarity needed for the real answer