The Story I was diagnosing a long-standing problem in one of our core queries today. I was quite surprised when I saw the below results when I requested the execution plan of the query in question. Feeling snarky, I went ahead and implemented the suggested changes and sure enough, I got the query in question [...]
