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.

 

No comments:

Post a Comment

Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists

If you received below error while attaching a .mdf file in cluster environment please follow below steps to resolve the issue ERROR Ca...