The last one might be heped by trace flag 4199. You can apply it to individual queries with option (querytraceon 4199): https://blogs.msdn.microsoft.com/psssql

The last one might be heped by trace flag 4199. You can apply it to individual queries with option (querytraceon 4199): https://blogs.msdn.microsoft.com/psssql/2010/09/01/slow-query-performance-because-inaccurate-cardinality-estimate-when-using-anti-semi-join-following-upgrade-from-sql-server-2000/ https://blogs.msdn.microsoft.com/psssql/2010/09/01/slow-quer...