Prioritize queries MS SQL Server
I was advised on this page: http://tek-tips.com/viewthread.cfm?qid=1063611&page=1
of a couple ideas on how to "set" the priority of a query in MSSQL or throttle a query so that it doesn't consume all available CPU and hard drive bandwidth.
MAXDOP apparently locks the query to use a single CPU, leaving the other(s) for other queries. Better than nothing.
>> Leonard Chan's Homepage
>> Scribble Web
>> Prioritize queries MS SQL Server