Browse by Tags

Related Posts

Blog Post: Upgrading your SQL Server 2012 to use Power View for Multidimensional

Mahmoud El-Wessimy

Hi, If anyone is interested to upgrade his VM to be SQL Server 2012 SP1 CU4 to be able to use the PowerView for OLAP. I encountered several issues so below is the safe path J 1- First check your SQL Server 2012 version: (Very Important as I didn’t notice and it costs me lots of time) The easiest...

on 27 Jun 2013
Blog Post: The Diagonal Warehouse Design

Wagdy Ishac

Have you ever been in a situation when designing your warehouse where you had some measures that could not be grouped together due to dimensionality differences? A few measures that you can’t put into one Fact and of course, like me, you hate the idea of a Fact for each measure. I’ve been...

on 29 Nov 2010
Blog Post: ColumnStore Index Quick view and Performance test (Video)

Wagdy Ishac

SQL Server 2012 introduces a new data warehouse query acceleration feature based on a new type of index called the columnstore. This new index, combined with enhanced query optimization and execution features, improves data warehouse query performance by hundreds to thousands of times in some cases,...

on 6 Feb 2012