Archives: February 2012
I was once asked in a job interview if I knew what a Cartesian/Cross Join was.
A more interesting question is: How can a Cross Join be useful?
There are actually many good reasons to use a Cross Join. Outlined below are a couple the most common scenarios that I… Read more
2 comments, 1,223 reads
Posted in Microsoft Business Intelligence and Data Warehousing on 19 February 2012
Hashing can be useful in Data Warehousing as well It can give you the ability to break large problems into smaller more manageable sizes or scale out your ETL process ;) PDW even uses a similar method to distribute data internally among all the compute nodes.
In reality there is… Read more
3 comments, 4,760 reads
Posted in Microsoft Business Intelligence and Data Warehousing on 1 February 2012