Getting Started with SQL Server In-Memory OLTP – Part 2

In my previous article of this blog series, I introduced SQL Server In-Memory OLTP and explained how it is possible to create an In-Memory OLTP – enabled database. Also, I showed via simple examples, how easy is to create memory-optimized tables (durable and non-durable). Today we are going to talk about naively-compiled stored procedures as well … Read more…

Getting Started with SQL Server In-Memory OLTP – Part 1

SQL Server In-Memory OLTP is a powerful engine integrated into the SQL Server Engine (version 2014 and later), optimized for Online Transaction Processing (OLTP). This article helps you getting started with SQL Server In-Memory OLTP and it is the first part in a series of articles focusing on SQL Server In-Memory OLTP.   An Introduction to SQL … Read more…

In-Memory OLTP Simulator Frequently Asked Questions (FAQ)

Please read below for In-Memory OLTP Simulator Frequently Asked Questions (FAQ): What is In-Memory OLTP Simulator? In-Memory OLTP Simulator is third-party tool that allows the user to easily create and run scenarios with different workloads against the In-Memory OLTP Engine of SQL Server®. What is a Simulation Scenario? A simulation scenario is a set of … Read more…

In-Memory Optimization in SQL Server: A Simple Experiment

Introduction In one of my previous articles I briefly introduced In-Memory Optimization in SQL Server. In this article we will conduct a simple experiment utilizing this new technology and discussing the benefits. The experiment will be organized in the following steps: Create the In-Memory processing enabled database Create the tables (disk-based, memory-enabled) Populate the tables … Read more…

Introducing In-Memory Optimization in SQL Server

In-Memory OLTP (codenamed “Hekaton”) is the most significant feature originally shipped with SQL Server 2014. It is Microsoft’s new technology which is fully integrated into SQL Server’s Database Engine. In-Memory OLTP introduces new data structures for optimizing the performance of OLTP workloads. These data structures are called “memory-optimized” tables and along with natively compiled stored … Read more…

The In-Memory OLTP Engine in SQL Server 2014: An Overview

A few days ago, on March 21st, I participated as an invited speaker at Microsoft Conference 2014 that took place in Nicosia, Cyprus. My session was on SQL Server 2014 and specifically about what’s new in this release of SQL Server. My session’s agenda was on the following areas of new features on SQL Server: … Read more…