SQL Server Customer Advisory Team - SQL Server Best Practices

Enabling SQL Server customers to navigate the most challenging frontiers of large scale data management.

Whitepapers

Analysis Services Distinct Count Optimization

SQL Server Best Practices Article

Published: April 17, 2008
Writer: Denny Lee
Contributors: Richard Tkachuk, Akshai Mirchandani, Sasha (Alexander) Berger, Thomas Kejser, Stuart Ozer
Technical Reviewers: Steve Pontello, Lindsey Allen, Lubor Kollar, Nicholas Dritsas, Ricardo Silva, Dave Wickert, Anne Zorner

Applies To: SQL Server 2005 SP2
Note: The tests in this white paper were performed using SQL Server 2005 SP2; however, they also apply to SQL Server 2008.

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.

For more information, please refer to the Analysis Services Distinct Count Optimization whitepaper.

Published Apr 17 2008, 05:40 PM by denny.lee

Filed under: Analysis Services, Distinct Count

Comments

No Comments

About denny.lee

Denny Lee is a Senior Program Manager based out of Redmond, WA in the SQLCAT Best Practices Team. He has more than 12 years experience as a developer and consultant implementing software solutions to complex OLTP and data warehousing problems. His industry experience includes accounting, human resources, automotive, retail, web analytics, telecommunications, and healthcare. He had helped create the first OLAP Services reporting application in production at Microsoft and is a co-author of “SQL Server 2000 Data Warehousing with Analysis Services” and “Transforming Healthcare through Information [Ed. Joan Ash] (2008)”. In addition to contributing to the SQLCAT Blog, SQL Server Best Practices, and SQLCAT.com, you can also review Denny's Space (http://denster.spaces.live.com). Denny specializes in developing solutions for Enterprise Data Warehousing, Analysis Services, and Data Mining; he also has focuses in the areas of Privacy and Healthcare.