Natively Compiled Stored Procedures
SQL Server 2014 introduces In-Memory OLTP, which also introduces the concept of native compilation. SQL Server 2014 can now natively compile stored procedures that access memory-optimized tables. Native compilation allows faster data access and more efficient query execution than normal T-SQL Stored procedures which are processed as interpreted Transact-SQL.
The main difference between interpreted stored procedures and natively compiled stored procedures is that an interpreted stored procedure isn’t compiled until its first execution whereas a natively compiled stored procedure is compiled when it is created. That compile process first translates the stored procedure code into C code, and then into machine ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
