I've done my best to follow Why is my query suddenly slower than it was yesterday?
The ShowPlanXML parses fine with SQL Sentry Plan Explorer but not via brentozar.com/pastetheplan (not sure why) so I have pasted text files to my github instead below:
Here is the DDL and TSQL I am executing.
Here is the bad query plan (times out). PasteThePlan
Here is the good query plan. PasteThePlan
Any idea how I can more reliably get the engine to use a "good" query plan? Thank you!