My statistics are up to date, histogram looks good, but still getting terrible execution plans. Estimated vs actual is always way off.

Joshua Guttman 2017-03-22 21:17:40

Vlady Oselsky 2017-03-23 19:08:14
Run your query in Plan Explorer and upload new plan. When running query in Plan Explorer you get additional information that is not collected by SSMS and then opening plan through plug in.
Joshua Guttman 2017-03-23 19:15:11
Running my query in plan explorer is how I got here.
Joshua Guttman 2017-03-23 19:16:29
Oh, you "Run" the query. Got ya.
Joshua Guttman 2017-03-23 19:30:57
Ok, that was much nicer information but I still couldn't find anything wrong with the stats. I uploaded the new execution plan.