It likely affects different people differently. Moderate alcohol consumption doesn't seem to have a long term cognitive affect for me. No difference in cognitive abilities if I had 2-3 drinks the night before or a few months before. I'd imagine heavy drinking has a different impact, but have much experience on that. Overall, it would likely be healthier to not drink.