How to force query to execute on a single processor core without affecting other queries?

For example there is a case when we have database server with eight quad-core processors.The database executes complex queries to generate reports.We need to  to force query to execute on a single processor core without affecting other queries.In this case the best option is using query hint OPRION (MAXDOP 1)The OPTION (MAXDOP) Transact-SQL query hints can override the max degree of parallelism configuration option … Continue reading How to force query to execute on a single processor core without affecting other queries?