O'Reilly logo

Microsoft® SQL Server® 2012 Analysis Services: The BISM Tabular Model by Alberto Ferrari Marco Russo and Chris Webb

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 9. Understanding xVelocity and DirectQuery

In the first chapters of this book, you learned what a Tabular model is, how to build and query a Tabular model, and how to use DAX to implement more advanced calculations. Now you take a look at the internal engine of a Tabular model. This knowledge can affect the way you model your data to optimize memory consumption and overall performance.

In this chapter, you discover the internal architecture of Analysis Services 2012 for Tabular models. You can deploy a Tabular model by choosing between the In-Memory mode (xVelocity in-memory analytics engine, also known as VertiPaq) and the Microsoft SQL Server–based mode (DirectQuery). (Because the xVelocity name has been introduced late in the development ...

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