Improve query performance for aggregated and joined data with Indexed Views, using SQL Server 2012

In this session will describe how to improve your query performance by using SQL Server 2012 Indexed Views. We'll provide a brief overview of Indexed Views, review performance gains achieved from Indexed Views, applications that benefit using Indexed Views and finally illustrate an example Indexed Views usage. [More]

Creating a New Named Set using SQL Server Analysis Services 2012 Cube Designer

In this session we'll show you how to create a Named Set in Analysis Services 2012 Cube Designer. We'll explain what a Named Set is, the difference between Static and Dynamic Named Sets and finally, demonstrate how to define a Named Set using Analysis Services 2012 Cube Designer. [More]