Our production server had a problem with very large cached plans that were only run once. So they were hogging memory for no good reason. I didn’t know how to avoid storing these in the plan cache until I found the answer today.
Just use the OPTION(RECOMPILE) or WITH RECOMPILE hints.
I thought this was an excellent post, where the writer says that WITH RECOMPILE could be better named WITH COMPILE_NO_CACHE.