Microsoft SQL Server 2014 Unleashed

What’s New in Creating and Managing Stored Procedures

SQL Server 2014 doesn’t introduce any significant changes to the creation and functionality of stored procedures over what was available in SQL Server 2012, but does add the concept of natively compiled stored procedures. Natively compiled stored procedures are stored procedures that access memory-optimized tables and can be compiled to native code, allowing for more efficient execution of queries and business logic. This chapter provides only an overview of natively compiled stored procedures. For more details on creating and using natively compiled stored procedures, see Chapter 33, “In-Memory Optimization and the Buffer Pool Extension.”