O'Reilly logo

Microsoft SQL Server 2014 Unleashed by Paul Bertucci, Alex T. Silverstein, Chris Gallelli, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required