Any canine that destroys your place while you are away. The most common casualties of dog the demolisher include window drapes, windowsills, walls, coffee tables and blinds.
Duder 1: "Holy fuck dude what happened to all your shit?"
Duder 2: "My damn border collie chewed the shit out of my drapes and tore some paint off the walls. This shit is going to cost me like $500 bucks to fix."
Means very drunk usually or it can mean a person is highly affected by narcotics. Generally the implication is so intoxicated that they lose control of their motor abilities, essentially either passing out or sitting in a still stupor.