As always I used to create ordinary stored procedures regarding the second option for creating stored procedure called "Natively Compiled Stored Procedure" I wanna know if there is any performance benefit to using compiled one?
Is there anyone can Help to find out? Thanks