You can output to the buffer as a target. However, that's not recommended. It puts more of a load on the system than output to a file. I prefer a...

More than one plan usually indicates different statistics distributions for the parameters involved in the query. Say, filtering on ID = 42 returns 10,000 rows and filtering on ID =...

Would some of these free tools be a starting point for someone unfamiliar troubleshooting ?

https://www.idera.com/productssolutions/freetools/

Other companies may have similar tools, and most will also offer free trials of...

To a degree, the difference between ON & WHERE, can be, but isn't entirely, syntactic sugar. However, what I say is, for clarity sake, put filter criteria in...

Grant, sorry to be going on about this.

But just to be clear, are you saying that if not for the fact that I'm working with a OUTER JOIN everything...

To a degree, the difference between ON & WHERE, can be, but isn't entirely, syntactic sugar. However, what I say is, for clarity sake, put filter criteria in the WHERE...

Ed has beat me to it.

So, you're going for a swim in the deep end of the pool.

Let's start with what you shouldn't do. Don't rebuild the indexes. Probably, they hit issues in the past,...

Although, if you move that part of the WHERE clause to the ON clause, you should still get an outer join.

From your keyboard to the ears of the gods.

Absolutely "Babylon 5" was and is the best does not mean I watch any other science fiction fantasy if I can get my hands on it! I happen to...

Yeah, plan forcing will translate. Automated tuning won't. It will have to "relearn" the automated tuning stuff. Also doesn't survive reboots.

Yeah, I know that one. Thanks!

Oh, I've got...

I can hear the questions asked in the voices of the characters.  Thank you for the nostalgia!

I agree as well with what you wrote.  Sure, I make most of...