LP Logo

LobsterPot Solutions™ is proud to be a Gold Competency Partner in the Microsoft Partner Network.

PDW Query Optimization

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.