SQL Server Best Practices Article
Published: April 17, 2008Writer: Denny LeeContributors: Richard Tkachuk, Akshai Mirchandani, Sasha (Alexander) Berger, Thomas Kejser, Stuart OzerTechnical Reviewers: Steve Pontello, Lindsey Allen, Lubor Kollar, Nicholas Dritsas, Ricardo Silva, Dave Wickert, Anne Zorner
Applies To: SQL Server 2005 SP2Note: 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.
Authors: Thomas Kejser, Denny Lee Contributors: Runying Mao Technical Reviewers: Burzin Patel, Kevin
This is a great whitepaper and has/will be useful to many cube designers.
I would like to add that whenever someone is looking at putting in a Distinct Count measure, they should understand the ramifications (cost) and understand that there is an alternative - to use dynamic MDX on the dimension key. See richardlees.blogspot.com/.../alternative-to-physical-distinct-count.html
Note: I am not suggesting that people avoid Distinct Count, just that they know the cost and are aware that there is an alternative and check that it doesn't better suit their needs.
Richard
Pingback from Analysis Services Distinct Count Optimization « Denny Lee
Pingback from Top 10 SQL Server Integration Services Best Practices - .NET Explored
Normal 0 false false false RU X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name
Die zehn besten SQL Server Integration Services-Methoden Autoren: Thomas Kejser, Denny Lee Mitwirkende
A Real Practices Case Study at Xbox LIVE Authors : Joseph Szymanski, Tyson Solberg, Denny Lee Technical
Авторы: Томас Кайзер (Thomas Kejser), Дэнни Ли (Denny Lee)Соавторы: Раньюин Мао (Runying Mao)Технические...
by Denny Lee As many of you know from the various blogs, whitepapers, and conferences from SQLCAT, there
Pingback from Why the obsession with random I/O within the context of SSAS? - MSDN Blogs
Pingback from At a Crossroads … from Tier-1 SSAS to BigData! « Denny Lee
Pingback from At a Crossroads … from Tier-1 SSAS to BigData! « Denny Lee
Pingback from At a Crossroads … from SSAS to BigData! « Denny Lee
Pingback from Top 10 SQL Server Integration Services Best Practices | devblogging.com
Thanks. It's realy interesting