The reason he'll remember it, though, is because of what happened on the pitch right before.
Brian Fuentes missed with a pitch, and Drew dropped his bat and started jogging down to first base thinking he'd drawn a walk to put runners at first and second. The only problem with that was it was only ball three.
"It was my most embarrassing moment," said Drew, who laughed as he walked back toward the batter's box. "Can't do anything about it."
The win ended the D-backs' 11-game road losing streak, but they could not gain ground on the Dodgers in the National League West with eight games left to play. The Dodgers beat the Giants, 10-7, to remain 3 1/2 games ahead of the D-backs.
"We're going to come out give our best effort and see what happens," Drew said.
On-deck hitter Justin Upton wasn't sure where Drew was going after the 2-2 pitch.
"I wondered what he was doing," Upton said.
One pitch later, the Rockies wished they could have given Drew the walk, as he lifted a fly ball that landed just over the 20-foot wall in right for a homer.
"I knew I hit it well, that was the thing," Drew said. "I knew I hit it well, and I knew I hit it high. The thing was it's a big wall out there. Honestly, I didn't think it would go out. I thought I had a shot. I didn't know because I saw [right fielder Jeff] Baker running. It's a great feeling when you see it go out."
Especially when you thought you had walked on the pitch beforehand, not to mention the ball down the right-field line he hit earlier in the at-bat that he thought might drop for a double.
Then there was the fact that he was facing Fuentes, who is tough against lefties like Drew.
"He just missed location," Rockies manager Clint Hurdle said of Fuentes. "He's been on a tremendous roll. You've got to give Drew some credit, that's not an easy at-bat."
Drew's homer bailed the D-backs out of what would have been an ugly loss.
"We gave them a couple of runs, literally gave them a couple of runs," Melvin said.
Indeed, the D-backs grabbed a 2-0 lead early and then with the bases loaded and one out in the fourth, Doug Davis got a cutter in on Baker's hands, breaking his bat as he flared a ball just beyond second base. A miscommunication between Drew at short and second baseman Augie Ojeda let the ball drop as a run scored.
"Those things are going to happen," Davis said. "They're going to fall in sometimes. You just have to go on to the next batter. I just really slowed the game down at that point."
The Rockies tied the game two innings later on Baker's 11th homer of the year.
The D-backs managed to reclaim the lead, 3-2, in the seventh, when they capitalized on an error by Rockies center fielder Willy Taveras.
They gave it back in the eighth when Drew tried to throw Troy Tulowitzki out at third on a grounder. Drew double-clutched getting the ball out of his glove and Tulowitzki was safe. He scored one batter later on a sacrifice fly.
That took away any chance for Davis to pick up the win. The left-hander allowed just two runs over six innings, but for the fourth straight start ended up with a no-decision.
Steve Gilbert is a reporter for MLB.com. This story was not subject to the approval of Major League Baseball or its clubs.