My friends over at Media Temple have promoted a fantastic guide to DPI, and so much more. This article really covers it all and in an outstanding way. I can't recommend it enough. Thanks to Media Temple for pointing it out, and thanks to Sebastien for writing this. Bravo!

http://sebastien-gabriel.com/designers-guide-to-dpi