In 'The Sign of Four,' Sherlock Holmes explicitly discusses his use of cocaine and injects a 7% solution when bored. While he does use cocaine in several Conan Doyle stories, this is one of the most prominent instances. The other works listed don't feature his drug use as prominently.