The reference there is that when he wasn't on a case he had a sort-of mini breakdown during which he would use heroin (remember, it was thought to be a beneficial drug in the late 19th century) to calm himself.