Earlier I wrote a blog post about the Location of Natively Compiled Stored Procedure and Naming Convention. In this blog post, I wrote about location of natively compiled stored procedures.
In the blog post, I have used following image.
One of the questions which I have received was what do various extensions like c, dll, obj etc means. My friend Balmukund Lakhani explains that very well in the his blog post, however for the reference it is listed here once again.
|.c||C source file generated by In-Memory engine|
|.dll||Natively compiled DLL to be loaded into SQL Server process|
|.mat.xml||MAT export file|
|.obj||Object file generated by C compiler|
|.out||Compiler output file|
|.pdb||Symbol file for the dll. Used for debugging code issues.|
Let me know what do you think of the native stored procedure. Tell you the truth, I have not used this feature so far and I have very limited experience, but again, Microsoft has included this feature in the SQL Server so I assume there will be demand of this feature and some of the biggest customers must be using this feature across their big applications.
Let me know what is your opinion in the comment section.
Reference: Pinal Dave (https://blog.sqlauthority.com)