O'Reilly logo

Professional Microsoft SQL Server 2014 Administration by Brian Knight, Ross LoForte, Steven Wort, Bradley Ball, Adam Jorgensen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 9In-Memory OLTP

WHAT'S IN THIS CHAPTER?

  • Using and implementing in-memory OLTP
  • Creating natively compiled stored procedures
  • Getting to know the Analyze, Report, and Migrate (ARM) tool

WROX.COM CODE DOWNLOADS FOR THIS CHAPTER

The wrox.com code downloads for this chapter are found at www.wrox.com/go/prosql2014admin on the Download Code tab. The code is in the Chapter 9 download and individually named according to the names throughout the chapter.

In-memory online transaction processing (OLTP) represents one of the most significant changes in SQL Server 2014. To fully appreciate in-memory OLTP, you must understand what the technology is, what it is meant to do, and how it is comparable to other in-memory technologies that are competitors of Microsoft. This holistic view of the technology will enable you to determine if and when you should use in-memory OLTP.

In this chapter, you learn how to create in-memory OLTP tables, how to create natively compiled stored procedures, how in-memory OLTP is integrated into the traditional SQL Server stack, and how to leverage the Analyze, Report, and Migrate (ARM) tool.

USING AND IMPLEMENTING IN-MEMORY OLTP

In-memory OLTP is an enterprise-level feature that brings to businesses and users of all sizes performance that was previously only attainable to organizations that could afford to spend several hundreds of thousands of dollars on hardware. It is available in SQL Server 2014 Developer, Evaluation, and Enterprise editions only. To ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required