Mar 2nd, 2013
"This module performs additional validation when a node is created or updated by a user to require that a node's title, author, language, and CCK fields are unique within a given context."
There are many different contexts including content type. So, for example, you could make sure that nodes of a certain content type have unique titles.