show_missing_stats shows details of useful statistics missing from SARG / Join columns.

It is important to note there are several situations where show_missing_stats will not print.

1. If you run a "stored-procedure" and there is a current plan in the master..sysqueryplans", the "show_missing_statistics" will not print anything. You can do one of 2 things.
• Run the stored-procedure with the recompile option. i.e. "exec with recompile"
• If the problem is a long running query and you do not want to wait a long time for the result then before you run the query you can execute "set noexec on". The only problem is, if there is a current query plan in sysqueryplans, even with the "with recompile" it won't work. In this situation you would first have to delete the query plan from sysqueryplans.
2. If you run an ad-hoc query the query plans for these are not stored in sysqueryplans. Ad-hoc query plan is created every time you run any ad-hoc query unless you have activated "statement cache". If "statement cache" is active on the server then you have the same problem as with "stored-procedures" and "procedure cache". Fortunately there is an easy solution here. At the session level "set statement_cache off" and the problem is solved.
3. If "capture metrics" is activated on the server this can cause "show_missing_stats" not to print. Again there is a simple solution for this that is to "set metrics capture off" at the session level and the problem is solved.