Author Topic: SQL Server 2014 : WHAT-WHY-HOW  (Read 254 times)

Offline anirban

  • Jr. Member
  • **
  • Posts: 58
    • View Profile
SQL Server 2014 : WHAT-WHY-HOW
« 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
Shikha Anirban
Assistant Professor
Dept. of SWE, FSIT
Daffodil International University