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 […]
Read more →Archive for September 2012
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 […]
Read more →