O'Reilly logo

Tabular Modeling with SQL Server 2016 Analysis Services Cookbook by Derek Wilson

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 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 ...

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