Hilary Cotter is a SQL Server MVP specializing in replication, and full-text search. He recently published a book on replication and is writing another about Microsoft search technologies. Hilary has been involved in IT for 21 years and is Director of Text Mining and Database Strategy for RelevantNoise.com - dedicated to mining blogs for business intelligence.
This article discusses three common problems DBAs are likely to encounter when columns have an identity property that will auto-increment its value when data is inserted. These problems are humorously referred to as the identity crisis.
… Read more