I wrote this in 2010, before Clustered Column Store Indexes, SQL Pools (so rule 3 looks a bit odd), and before date data type was mainstream, but the rest of these still look quite Thou Shalt use something that exists in your query as a partition keyThou shalt not make up a surrogate partition keyThou … Continue reading Top 10 SQL Partition Commandments
Tag: EDW
Blast from the past. I wrote this is 2008 and at one point we had it made into a poster for the office rule whereby on code review we not say a word but just point to the poster. Not sure how well this stood the test of time now it is 2021 so many … Continue reading Top 10 SSIS/DW Commandments