Stored procedure compilation and caching
In this post I will explain when the actual caching (the stored procedure is placed in the procedure cache ) takes place.
Many people think that the execution plan of a stored procedure is cached in the procedure cache when the stored procedure is created. That is a mistake.(
read more)