Finally, after about 7 months of analysis, customer validation, and just general randomization – I have finally propped up the Analysis Services Distinct Count Optimization whitepaper which is available here: http://sqlcat.com/whitepapers/archive/2008/04/17/analysis-services-distinct-count-optimization.aspx Quick summary of this whitepaper: Distinct count (such as unique visitor counts on a Web site) calculations provide valuable information but come with a number of performance challenges. This white paper describes tests that were performed to determine how best to optimize these calculations and includes best practices based on the test results.
Month: April 2008
Analysis Services Distinct Count Optimization
Finally, after about 7 months of analysis, customer validation, and just general randomization – I have finally propped up the Analysis Services Distinct Count Optimization whitepaper which is available here: http://sqlcat.com/whitepapers/archive/2008/04/17/analysis-services-distinct-count-optimization.aspx . Quick summary of this whitepaper: Distinct count (such as unique visitor counts on a Web site) calculations provide valuable information but come with a number of performance challenges. This white paper describes tests that were performed to determine how best to optimize these calculations and includes best practices based on the test results.
Denny Lee 