Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

SQL Server 2014 In-Memory OLTP Overview

PASS Data Community Summit via YouTube

Overview

Explore the groundbreaking in-memory technology for optimizing OLTP workloads introduced in SQL Server 2014 in this comprehensive conference talk. Delve into the user scenarios and hardware trends driving the key architectural pillars of memory optimization, no lock/latch concurrency control, and native compilation. Discover how decreasing memory costs, many-core processors, and stalling CPU clock rates have influenced these innovations. Gain insights into the integration of in-memory OLTP with other SQL Server components. Watch a demonstration showcasing the practical applications of this technology and participate in a Q&A session to deepen your understanding of SQL Server 2014's in-memory capabilities for enhanced database performance.

Syllabus

Introduction
Business Analytics Conference
Kevin Farley
SQL Server 2014
Memory Technologies
Why OLTP
Hardware Trends
InMemory OLTP
Demo
Block Diagram
InMemory Roast or Columnstore
Demonstration
Questions

Taught by

PASS Data Community Summit

Reviews

Start your review of SQL Server 2014 In-Memory OLTP Overview

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.