2013. március 23., szombat

Msg 11305

Execute a query on SQL Server 2008 such as this:
  1. SELECT COUNT (ItemID) OVER (ORDER BY OrderID) FROM OrderDetails;
You get the following error message:

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.