From the course: Developing Microsoft SQL Server 2016 Databases
Join today to access over 25,500 courses taught by industry experts.
Write a native compiled stored procedure - SQL Server Tutorial
From the course: Developing Microsoft SQL Server 2016 Databases
Write a native compiled stored procedure
- [Instructor] We just saw that in-memory optimized tables are stored as natively complied DLL files. This makes them very efficient to process as the code doesn't have to be interpreted by SQL Server first before running it against the server hardware. Start procedures can gain this benefit too. With a natively complied store procedure you can increase the performance of the procedure by removing the added step of having SQL Server interpret the statements before converting them to native code each time they're called. Let's take a look at this by creating a new database. This time I'll call it memory optimized procedures and we'll go ahead and start using it. Then we're going to alter the database to add in the file group for our memory optimized data, just like we did in the last movie. Finally, we'll alter the database again to create a new file and for me, I'm going to place it in my C drive in a folder that I've…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.