Published 20 November 2017
Settings lead to procedure recompilation (only in proc/trigger)
Setting this option from within batch leads to batch recompilation.
Where possible, batches, triggers and procedures should be compiled just once and their plans reused when called again. This yields better performance and uses less memory resource. Anything that changes the execution context will force a recompile.