Need to spot In-Memory OLTP tables among thousands of tables? I show a simple T-SQL query and the SSMS options that list only those tables.
SQL SERVER – Extension of the SQL Server Natively Compiled Stored Procedures
What are the .c, .dll, .obj and .pdb files created for Natively Compiled Stored Procedures in SQL Server 2014? A quick list of each extension and what it does.
SQL SERVER – Location of Natively Compiled Stored Procedure and Naming Convention
Why is it called a natively compiled stored procedure when the code is T-SQL? I explain, and show a DMV query that finds where its DLL is loaded from.
SQL SERVER – Beginning In-Memory OLTP with Sample Example
Beginning In-Memory OLTP in SQL Server 2014 is easier than it looks. I explain why we need it in simple words, with a sample example to get you started.
SQL SERVER – Introduction to SQL Server 2014 In-Memory OLTP
An introduction to In-Memory OLTP in SQL Server 2014, the Hekaton engine that keeps busy tables in memory without losing a record and still runs most T-SQL.