Daffodil International University

Faculty of Science and Information Technology => Science and Information => Topic started by: anirban on July 14, 2014, 01:30:07 PM

Title: SQL Server 2014 : WHAT-WHY-HOW
Post by: anirban on July 14, 2014, 01:30:07 PM

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