This question already has an answer here:
How do I enable Parallel Data Warehouse on my Microsoft SQL Server. I am trying to run this SQL statement below and received this error.
Msg 11305, Level 15, State 10, Line 2 The Parallel Data Warehouse (PDW) features are not enabled.
select A.gender, A.firstname, A.weight, SUM(a.weight) over (partition by a.gender order by a.weight) as 'New Column' from ChildStat A order by a.gender, a.weight;