Browse by Tags

• Crossjoin
• Data Warehousing
• MDX
• Microsoft
• Query
• SQL Server 2008
• SSAS

• SQL Server Fast Track Data Warehouse

  Microsoft has announced a range of pre configured servers for BI applications, specifically for relational data warehouses but also including Analysis Services. Full details can be found on http://www.microsoft.com/sqlserver/2008/en/us/fasttrack.aspx... Posted Feb 24 2009, 04:30 PM by IanMarritt with | with no comments Filed under: Microsoft, Performance, SQL Server 2008, Data Warehousing

• MDX CROSSJOIN Performance

  Run the following 2 queries on adventure works with clear cache and note the execution times. QUERY 1 WITH MEMBER Measures.PerfmonTest AS Count( Crossjoin( [Promotion].[Promotions].[Promotion] , Filter([Customer].[Customer Geography].[Customer], RIGHT... Posted Jun 13 2008, 03:11 PM by ShaunRyan with | with 1 comment(s) Filed under: Query, Performance, MDX, SSAS, Crossjoin