I am a novice and don't know much about the SQL server engine but Microsoft documentation claims that "Microsoft® SQL Server™ automatically recompiles stored procedures and triggers when it is advantageous to do so."

I found this claim at http://msdn2.microsoft.com/en-us/library/aa238892(SQL.80).aspx

Not sure what is it. Could some expert explain?