Based on the fact that you said the query ran fine again in production after you did index maintenance (I'm presuming reorganized) and updated statistics, most likely your statistics in...

I would think you could do this using the Resource Governor feature.  Create a resource pool to limit the CPU usage for the login in question.

Please note, I...

So, of course what happens?
No one came by needing anything...

Ever have one of those days where you know that as soon as you go put your lunch in the microwave, someone's going to call your desk or walk over...

Vic,
Presuming your server is using Windows Authentication and your front end (which you indicated is MS Access) is being run as the logged in user on the workstation, SQL...

Has anyone had any issues enabling the two registry keys to enable the Meltdown / Spectre fixes for the OS?
https://support.microsoft.com/en-us/help/4072698/windows-server-guidance-to-protect-against-the-speculative-execution
I enabled these yesterday on...

I find it amusing that someone responded to a topic (that I'd replied to and hopefully answered the OPs question) with a link to a topic on basically the same...