Chapter 6.  In-Memory Versus DirectQuery Mode

In this chapter, we will cover the following recipes:

  • Creating a new DirectQuery project
  • Configuring DirectQuery table partitions
  • Testing DirectQuery mode

Introduction

When developing a tabular model, you have two primary choices for where and how the data is stored and accessed from end user tools. Tabular models are unlike SQL Server Analysis Services Multidimensional models, which only store all data to disk. Tabular models by default store data in memory with an option for storing data to disk when appropriate. By storing the data in memory there is faster query performance since there is no disk I/O for retrieving data results. Modeling can be accomplished in visual studio and does not require a full ...

Get Tabular Modeling with SQL Server 2016 Analysis Services Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.