Thursday, September 18, 2014

SQL & PDW

SQL & PDW

 

·        Functions will not work in PDW Environment

·        Foreign keys does not support in PDW

·        Datatypes

o   No BLOBs

o   No CLR Types

o   No Numeric

o   Numeric replaced with decimal

·        In PDW you can’t use update/delete statements using joins.

·        You can’t do update statistics automatically.