• Interesting. Very surprised to learn you can enter duplicate values when inserting explicit values.

    Further surprised to learn that you can get duplicate values by resetting the identity seed, according to this person:

    http://beyondrelational.com/blogs/jacob/archive/2009/02/03/sql-server-identity-why-do-i-have-duplicate-identity-values.aspx