Optimizing Query Performance in Microsoft SQL Server 2008 Analysis Services

In this session we will take a deep dive into the enhancements of SQL Server 2008 Analysis Services. We'll analyze the MDX query evaluation internals, block evaluation vs. cell-by-cell evaluation, and the query performance improvements in Analysis Services 2008. We'll also show how to use the query trace capability to understand query execution plans, as well as show how to diagnose slow queries and provide techniques for optimizing them.