It's a common phrase that means to drink enough alcohol to pass out. Presumably because otherwise sleep would be difficult to find, due to withdrawal symptoms.