"Our results are consistent with the possibility, but do not prove, that regular moderate drinking decreases the risk of cognitive impairment in older men."
pops cork
Heavy alcohol use will destroy your memory though. See:
http://en.wikipedia.org/wiki/Wernicke%E2%80%93Korsakoff_syndrome