That’s a good observation. With window functions, parallelism is
currently considered only when there’s a window partition clause. The
use of a nonpartitioned window function, as is...
No it is not. I explain this in the following articles:
To get the top @n rows per customer use:
DECLARE @n AS BIGINT = 2;
SELECT TOP (1) WITH TIES orderid, orderdate, custid, empid, filler