Alcohol and dementia: What's the truth?

What do we know about the risks of dementia from drinking alcohol?