CHAPTER 15

image

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