© Benjamin Nevarez 2016

Benjamin Nevarez, High Performance SQL Server, 10.1007/978-1-4842-2271-3_6

6. SQL Server In-Memory Technologies

Benjamin Nevarez

(1)Santa Clarita, California, USA

This chapter covers in-memory databases along with some other new technologies and paradigms that radically depart from the traditional disk-based rowstore architecture and query-processing algorithms that most relational databases have been using for a few decades now. Current relational databases were architected back in the late 1970s, when hardware was totally different from what it is today and databases were too large to fit in memory and assumed to be kept on disk. In addition to faster processors and declining memory cost, memory capacity in current hardware ...

Get High Performance SQL Server: The Go Faster Book now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.