Archive for September, 2009

September 13th, 2009

Identity over-use: Surrogate vs Composite keys in SQL Server

The SQL Server ‘Identity’ column is a handy way of ensuring a unique primary key, but I have noticed a tendency for some database designs to over-use it.