Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Microsoft Business Intelligence and Data Warehousing

Garrett Edmondson, Independent Consultant MCITP & MCTS: 10+ years experience with BI stack.

Archives: February 2012

Cartesian/Cross Join

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,208 reads

Posted in Microsoft Business Intelligence and Data Warehousing on 19 February 2012

CHECKSUM vs HashBytes

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,672 reads

Posted in Microsoft Business Intelligence and Data Warehousing on 1 February 2012