Natively Compiled Stored Procedures

Now that disk-based stored procedures have been covered it’s time to look at natively compiled stored procedures. These procedures are built to execute against in-memory tables as quickly and as efficiently as possible. For the most part, the functionality available in standard stored procedures exists within natively compiled stored procedures, but there are important differences that this chapter will go through.

The aim of the chapter is to cover the differences that exist between creating a natively compiled stored procedure and creating a standard stored procedure, as well as to show the speed ...

Get Beginning SQL Server for Developers, Fourth Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.