Recently, Rob wrote a white paper about how some simple changes to a database design in Parallel Data Warehouse can leverage one of the lesser-known Query Optimizer methods, with significant results, removing all data movement from many queries. The paper was published on the Microsoft website at http://blogs.technet.com/b/dataplatforminsider/archive/2014/11/14/aps-best-practice-how-to-optimize-query-performance-by-minimizing-data-movement.aspx
The technique used here is one that may be familiar to experts in Query Optimization, but few people within the PDW space are familiar with it. This is just another reason why you should choose LobsterPot Solutions as your preferred APS / PDW implementation partner.
This post was originally published on December 6, 2014.