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

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