SQL Server Administration & Maintenance

SQT09 SQL Server InMemory Database Objects

11/19/2019

2:45pm - 4:00pm

Level: Intermediate

Denny Cherry

Owner and Principal Consultant

Denny Cherry & Associates Consulting

SQL Server 2017 is continuing to expand on the in-memory database features that were first introduced in SQL Server 2012 and have been enhanced in every version of SQL Server since.

During this session, we will explore the in-memory database tables which are known as the In-Memory OLTP features as well as reviewing the ColumnStore features.

During this presentation, we will also review the scope of the feature as well as reviewing the use cases and best practices for using in-memory database tables and when the in-memory database tables shouldn't be used.

You will learn:

  • In Memory OLTP
  • ColumnStore
  • Clustered ColumnStore