My statistics are up to date, histogram looks good, but still getting terrible execution plans. Estimated vs actual is always way off.
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.
2017-03-23 19:15:11
Running my query in plan explorer is how I got here.
2017-03-23 19:16:29
Oh, you "Run" the query. Got ya.
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.