Tag Archives: Natively Compiled Stored Procedures

Interesting facts about SQL Server 2014 Memory optimized tables and Natively compiled stored procedures

Posted on August 19, 2014 by vijred

  Stored Procedures that reference only memory-optimized tables can be natively compiled into machine code for additional performance improvements Only one MEMORY_OPTIMIZED_DATA Filegroup can be created on each database In Memory OLTL is Lock and Latch Free In-Memory OLTP is … Continue reading →

Posted in knowledge, Productivity, SQL, sql2014 | Tagged , , , , | Leave a comment

SQL 2014 New Feature – Natively Compiled Stored Procedure

Posted on February 17, 2014 by vijred

How is it different from normal Stored Procedure? A natively compiled stored procedure is compiled when it is created, rather than when it is executed. That compile process first translates the store procedure code into “C”, and then into machine … Continue reading →

Posted in SQL, sql2014 | Tagged , , , , , | Leave a comment