When a person overdoses on heroin and falls unconscious
Guy: Hey what's up with Steve?
Other Guy: Oh Sleepy Steve, he's just taking a needle nap
A phrase used by stereotypical rednecks, hillbillies, or southerners
Rufus: Well hell dingiddy dang! They done blown up my moonshine still!