The Power of MS SQL in Database Management
Compiled Stored Procedures in MS SQL
In MS SQL, stored procedures are compiled. This means that if a stored procedure is not already in memory/cache, it will be re-compiled at runtime before being used again and then placed back into the cache. As a rule of thumb, if a stored procedure is used frequently, it can be considered to always be compiled.