SQL Server Best Practices Article
Published: March 21, 2007
Writers: Matt Carroll
Contributors: Robert Zare, Edward Melomed, Akshai Mirchandani, Marius Dumitru, Siva Harinath
Technical Reviewers: Craig Utley, Nicholas Dritsas
Project Editor: Jeannine Nelson-Takaki
This paper outlines the recommended best practices for designing OLAP databases in Microsoft SQL Server 2005 Analysis Services to better meet the functional and performance needs of users. Designing a database for Online Analytical Processing (OLAP) databases is very different from designing a database for Online Transaction Processing (OLTP) and requires a different approach for achieving optimal results.
For more information, please refer to the OLAP Design Best Practices for Analysis Services 2005 whitepaper.
