Listing 1: Creating an SQL plan guide to force a query to run on a single CPU

USE AdventureWorks
GO
EXEC sp_create_plan_guide
    @name =
       N'plan_SalesOrderDetail_DOP1',
    @stmt = N'SELECT TOP 10 *
FROM Sales.SalesOrderDetail
ORDER BY UnitPrice DESC',
    @type = N'SQL',
    @module_or_batch = NULL,
    @params = NULL,
    @hints = N'OPTION (MAXDOP 1)';