I caught a review, a long time ago, that compared a bunch of standard primes. The nikon 1.4 and 1.8, the zeiss 1.(whatever) manual, I think a higher-end Sigma and some others. It actually turned out that the nikon 1.8 had the sharpest images...
To OP, 2nd on the DoF calculator. If you want to capture a Coca-cola can, you can figure on needing 3-4" of DoF. Figure on 12" to be safe (unless you use a measuring tape from the soda can to the sensor plane). And decide on achieving that DoF with either the aperture or focal distance. Personally, I'd put more pixels on it (and thereby stop down the aperture to whatever it needs to be; calculator will tell you). And since you're using a prime lens, I wouldn't be too concerned with sharpness. But that's just me. Stick that bad boy on a tripod, use a 2-second shutter delay (and mirror lock-up, if you have it) and let it rip!