Category Archives: Tabular

Comparing DirectQuery and ROLAP for real-time access

Posted on July 2, 2012 by

In the multidimensional model in SSAS, there is a storage mode called relational OLAP (ROLAP), which is the multidimensional solution for allowing real-time access to relational data sources.  In the tabular model in SSAS, the solution for real-time access is … Continue reading →

Posted in SQLServerPedia Syndication, SSAS, Tabular | Leave a comment

Tabular query modes: DirectQuery vs In-Memory

Posted on June 18, 2012 by

When using the Tabular model in SSAS, the deployment options screen offers four choices for “Query Mode”: DirectQuery, DirectQuery with In-Memory, In-Memory, In-Memory with DirectQuery.  Query Mode is used to specify the source from which query results are returned when … Continue reading →

Posted in SQLServerPedia Syndication, Tabular | 2 Comments

What happens when a SSAS Tabular model exceeds memory?

Posted on May 21, 2012 by

If you are using the Tabular model in SSAS, it will use the xVelocity technology to load your entire database in memory (greatly compressing the database).  So what happens if your database is too big to fit in memory?  You … Continue reading →

Posted in SQLServerPedia Syndication, SSAS, Tabular | 1 Comment

SQL Server 2012: Multidimensional vs tabular

Posted on April 4, 2012 by

To expand on what I talked about in SQL Server 2012 (“Denali”): Details on the next version of SSAS, there is a new data model called Tabular.  So when you are creating a new project, which model should you use, Multidimensional … Continue reading →

Posted in Data warehouse, SQL Server 2012, SQLServerPedia Syndication, SSAS, Tabular | 14 Comments

SQL Server 2012: xVelocity

Posted on March 19, 2012 by

After SQL Server 2012 was released this past week, I saw a few mentions from Microsoft about a new feature in SQL Server 2012 called “xVelocity”.  I have been using SQL Server 2012 for months now, playing with all the new … Continue reading →

Posted in SQL Server 2012, SQLServerPedia Syndication, Tabular | Leave a comment

SQL Server 2012: Tabular Models vs PowerPivot Models

Posted on March 14, 2012 by

In SQL Server 2012, there is a new data model, called tabular, that is part of the new feature called the Business Intelligence Semantic Model (BISM).  BISM also includes the multidimensional model (formally called the UDM). The Tabular model is based on … Continue reading →

Posted in PowerPivot, SQL Server 2012, SQLServerPedia Syndication, Tabular | Leave a comment

SQL Server 2012 (“Denali”): Installing SSAS Multidimensional vs Tabular Mode

Posted on July 15, 2011 by

As I play with the recently released CTP3 of SQL Server 2012, code name of Denali, I wanted to point something out about installing SSAS, since there is now two “modes” you can choose from due to the the new BI Semantic Model … Continue reading →

Posted in BISM, SQL Server, SQL Server 2012, SQLServerPedia Syndication, SSAS, Tabular | 1 Comment

SQL Server 2012 (“Denali”): Details on the next version of SSAS

Posted on June 27, 2011 by

At the recent TechEd North America 2011 conference, details on the next version of SQL Server 2012 (codename “Denali”) were released.  Part of those details were an update on the SQL Server Analysis Services (SSAS) roadmap.  The main new feature in … Continue reading →

Posted in BISM, SQL Server, SQL Server 2012, SQLServerPedia Syndication, SSAS, Tabular | 17 Comments