Recompilation in SQL Server 2005

Hi,

Below described is the SQL Server 2005 Batch Recompilation Process.
I will come up with the explanation as well as my work-around on the same in my next post.



References
[Mar04] Arun Marathe, Batch Compilation, Recompilation, and Plan Caching Issues in SQL Server 2005