In-Memory OLTP Archives - Page 6 of 6 - SQL Authority with Pinal Dave

SQL SERVER – Filter In-Memory OLTP Tables in SSMS

January 5, 2015

In-Memory OLTP, SQL Scripts, SQL Server Management Studio

Earlier I had written a blog about SQL SERVER – Beginning In-Memory OLTP with Sample Example which covers the basics of working with In-Memory OLTP. Though that post gets you started, one of my colleague asked me if there was an easier way to identify In-Memory Tables when working with SQL…

SQL SERVER – Extension of the SQL Server Natively Compiled Stored Procedures

September 27, 2014

Pinal Dave

SQL Tips and Tricks

In-Memory OLTP, SQL Server

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.

SQL SERVER – Location of Natively Compiled Stored Procedure and Naming Convention

September 16, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

In-Memory OLTP, SQL Memory

Yesterday I wrote about SQL SERVER – Beginning In-Memory OLTP with Sample Example. One of the questions I received right after I published a blog post was why do I call stored procedure natively coded stored procedure when the entire code is in T-SQL. Indeed a very good question. The…

SQL SERVER – Beginning In-Memory OLTP with Sample Example

September 15, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

In-Memory OLTP, SQL Memory

In-Memory OLTP is a wonderful new feature introduced in SQL Server 2014. My friend Balmukund Lakhani has written amazing series on A-Z of In-Memory on his blog. All serious learner should study it for deep understanding of the same subject. I will try to cover a few of the concepts…

SQL SERVER – Introduction to SQL Server 2014 In-Memory OLTP

August 8, 2014

Pinal Dave

SQL Performance

In-Memory OLTP, SQL Scripts, SQL Server

In SQL Server 2014 Microsoft has introduced a new database engine component called In-Memory OLTP aka project “Hekaton” which is fully integrated into the SQL Server Database Engine. It is optimized for OLTP workloads accessing memory resident data. In-memory OLTP helps us create memory optimized tables which in turn offer significant performance improvement for our typical OLTP workload.