SMT Member:
How to stop it? Only by making the rest of us 'suffer' for the actions of a, relative, few: By banning the sale and consumption of alcohol in airports and onboard commercial aircraft. It was possible with smoking, surely it's possible with alcohol as well.
In the case of smoking the issue was second hand smoke, not disruptive passengers. That ban came in stages: first, the smoking and non-smoking sections, followed a few years later by a total ban.
Alcohol normally does not affect other passengers either medically or otherwise. The airlines, at least as a group, will not ban alcoholic beverages. It simply won't happen.