Why Avoiding Multiple Code Blocks in a Stored Procedure

In this post I'm going to use information from the following Dynamic Management Views and Functions to show some information about the cached Execution Plans of the queries used in this post:

Continue here >