Dancing with Mr. Brownstone = Shooting Heroin. Song is about the band slamming it before shows and when partying. Thus why they had the rep of "show usually starts around 7, we go on stage about 9" as part of the lyrics state. Song also used the term "bindle" in the end which was a common nickname for a dime bag of H.
[ame=http://www.youtube.com/watch?v=b5VJa-sYsyU]Guns N' Roses - Mr. Brownstone - Live At The Ritz 88 - YouTube[/ame]