Question: are sql stored procedures compiled?
Answer: Native Compilation of Stored Procedures Stored procedures that are marked with NATIVE_COMPILATION are natively compiled. This means the Transact-SQL statements in the procedure are all compiled to native code for efficient execution of performance-critical business logic.