Tag: in-memory oltp

In memory Tables (OLTP) in Microsoft SQL Server Databases with Examples

Database administration, Memory Optimization, SQL Server • 2 Comments

What if 1 second of a transaction process is too long? You can tune your queries. But what if...
Read More

Using Indexes in SQL Server Memory-Optimized Tables

Database administration, Database development, Indexes, Memory Optimization, Performance Tuning

Introduction In this article, we will discuss how different types of indexes in SQL Server memory-optimized tables affect performance. We...
Read More

Creating and Accessing In-Memory OLTP Databases and Tables

Database administration, Memory Optimization

This is the second article in a series of articles about SQL Server In-Memory OLTP. The introductory article — SQL Server In-Memory OLTP,...
Read More

SQL Server In-Memory OLTP: The Basics

Database administration, Memory Optimization

This is the first article in a series of articles about In-Memory OLTP. It helps you to understand...
Read More

In-Memory OLTP: What’s new in SQL Server 2016

Database administration, Memory Optimization

SQL Server development team has added new features to In-Memory OLTP. All these features allow you to build new applications as well as to...
Read More
Close