Entries Published On September, 2012
70-463: Determine whether you need a star or snowflake schema…
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 scenarios I could come up with that would justify using a snowflake schema were the following: Short on Disk Space? …
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 objective was to gain an understanding of how they stacked up performance-wise with the IDENTITY property…which is the predominant design pattern …