Grant Fritchey sets up a showdown:
I recently presented a session on the Query Store at Data Saturday Rhineland and the question came up: If there’s already a query hint on a query, what happens when you try to force a similar query hint?
Yeah, OK, that is a weird one. I don’t know the answer, but I’m about to find out.
Click through for a very interesting demo. To be honest, I expected the opposite result, so this was surprising.