Try adding sp_statement_completed event.

It's an EXEC statement. The only things that have query hashes are the queries themselves, not exec of stored procedures (which this is)

Since you're capturing statement completed, you...

If the DB doesn't have constraints, finding the columns they should be on will likely be the least of the problems. Fixing the data so that constraints can be added...

Please do. I'd like to see some snapshots of the schedulers DMV under load.

Are you monitoring wait stats? If not, can you also take snapshots of sys.dm_os_wait_stats while...

Ok, I suspect what you're seeing is not SQL not using the other processors, but a side effect of how affinity is set on higher processors. Your observation that all...

This one? http://source.entelect.co.za/why-is-this-upsert-code-broken

It's my company's showcase site, which is probably why you couldn't find it. I do have a similar post that's still in draft on...

Can you please open the error log and post the startup messages (the first 20 or so messages from the log)? You can remove the server names and database names.

Both threads. I posted ~3 minutes before you (judging from when I received the emails). When I finished the posts, there were no replies.

Anyone who uses computers should be using password managers, so that's a no-brainer.