title: SQL server - Difference between Natively Compiled Stored Procedure and ordinary stored procedure
body: <p>As always I used to create ordinary stored procedures regarding the second option for creating stored procedure called "<code>Natively Compiled Stored Procedure</code>" I wanna know if there is any performance benefit to using compiled one?</p>
  
  <p>Is there anyone can Help to find out?
  Thanks </p>