title: What does it mean to "recompile" a stored procedure on a SQL Server?
body: <p>What does it mean to "recompile" a stored procedure on a SQL Server?
  Should this be a manual process or an automated one?
  What are the pros and cons of this process?
  Thank you!</p>