If you’re a Kimball purist like myself, the title of this post should give you pause. I came across this phrase when reviewing the SkillsMeasured section for the 70-463 exam. At the time, the only … Continue reading 70-463: Determine whether you need a star or snowflake schema…
Sequence vs Identity – Performance Comparison
Recently, as part of an effort to support a few database design choices, I spent a bit of time researching the performance characteristics of the new sequence objects available with SQL Server 2012. The main … Continue reading Sequence vs Identity – Performance Comparison