SQL Server 2014 : WHAT-WHY-HOW

[anirban]

SQL Server 2014 introduced native compiled stored procedure. In this process code are converted to machine code that stored into DLL files stored in a specific folder of SQL Server. Memory optimized Machine codes can be directly executed by processor without further compilation or interpretation. So it is faster than T-SQL stored procedure that we are using.

http://social.technet.microsoft.com/wiki/contents/articles/25254.sql-server-2014-what-why-how-natively-compiled-stored-procedures.aspx