SQL Server 2014 : WHAT-WHY-HOW

Author Topic: SQL Server 2014 : WHAT-WHY-HOW  (Read 380 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.

Shikha Anirban
Assistant Professor
Dept. of SWE, FSIT
Daffodil International University