Execute a query on SQL Server 2008 such as this:
- SELECT COUNT (ItemID) OVER (ORDER BY OrderID) FROM OrderDetails;
Msg 11305, Level 15, State 10, Line 1
The Parallel Data Warehouse (PDW) features are not enabled.
Really? Thank you for telling me but what can I do now?
OK, the reason of failure is simple. ORDER BY in OVER clause on an aggregate function works only in version 2012. But this message doesn't help much in debugging.