Configuring SQL Server for Optimization - Microsoft SQL Server 2012 Performance Tuning - page 395

2. To set the value of parallelism at the query level, execute the two following SELECT

queries, using SET STATISTICS TIME along with the MAXDOP option a few times,
and observe the value of SET STATISTICS TIME in the Message tab:
set statistics time on
SELECT
*
FROM
Sales.SalesOrderDetail
OPTION (MAXDOP 1)
set statistics time off
GO

set statistics time oN
SELECT
*
FROM
Sales.SalesOrderDetail
OPTION (MAXDOP 0)
set statistics time ofF

Here is the one of the screenshots of the preceding query, after running it a few times: