I had a good question from JP via a comment on my blog about whether you can use the MAXDOP query hint in Azure SQL Database. The answer? Yes.
Just to prove it, my first query I prevent parallelism via MAXDOP = 1.
SELECT * FROM [dbo].[GlobalAudi] ORDER BY Date OPTION (MAXDOP 1) GO
I check the operator properties of the clustered scan where parallel is false.
So what happens with the below query?
SELECT * FROM [dbo].[GlobalAudi] ORDER BY Date OPTION (MAXDOP 2) GO
It is as you would expect.
Now a question for you, which one was faster?