Analysis Services 2008 R2 Performance Guide

October 11, 2011 Leave a comment

Analysis Services 2008 R2 Performance Guide from sqlcat has just released.

That is the link

http://sqlcat.com/sqlcat/b/whitepapers/archive/2011/10/10/analysis-services-2008-r2-performance-guide.aspx

Download pdf

Advertisements

How to Use Excel’s CUBEMEMBER Function

September 7, 2011 Leave a comment

Where’s your mobile business intelligence strategy, Microsoft? – The Frontline – a blog from V3.co.uk

August 24, 2011 1 comment
Categories: Uncategorized

SQL Server PerfMon counters for tracking Windows memory

August 23, 2011 Leave a comment

Lock Pages in Memory … do you really need it?

August 23, 2011 Leave a comment

Last Ever Non Empty – a new, fast MDX approach (via Chris Webb’s BI Blog)

July 13, 2011 Leave a comment

Last Ever Non Empty - a new, fast MDX approach The last non empty semi-additive measure aggregation functionality in SSAS enterprise edition is very useful, but it doesn’t support one common business requirement: while it will give you the last non empty value within any given time period, it doesn’t handle the variation where you want to get the last non empty value of a measure from all preceding time periods (this is what I’m calling the ‘last ever non empty’ value). There are a number of … Read More

via Chris Webb’s BI Blog

Categories: Sql Server Analysis Services Tags: