Browse by Tags

• Architecture
• Availability
• Capacity
• Connectivity
• Consolidation
• design
• Distinct Count
• Featured
• Optimization
• Performance
• Precision
• Processing
• Querying
• reporting services
• SAN
• Scalability
• Scale-Out
• SQL Server
• SQL Server 2008
• Tuning
• Virtualization

• Analysis Services ROLAP for SQL Server Data Warehouses

  SQL Server Technical Case Study Writers: Denny Lee, Kay Unkroth Investigators: Denny Lee, Thomas Kejser Contributors: James Podgorski, Richard Tkachuk... Posted Aug 23 2010, 09:57 PM by denny.lee with | with 8 comment(s) Filed under: Performance, Analysis Services, Featured, Tuning, SQL Server, Architecture

• Develop Reporting Services reports using Analysis Services data; a SQL Server 2008 technical case study

  Writers: Nicholas Dritsas, Nopparat Leelavanich Contributors: Artich Asawachaiyawong, Sairung Inlert Technical Reviewers : Carl Rabeler, Robert Bruckner... Posted Jun 22 2010, 07:55 PM by Nicholas Dritsas with | with 11 comment(s) Filed under: Analysis Services, design, SQL Server, SQL Server 2008, reporting services

• Scale-Out Querying for Analysis Services with Read-Only Databases

  SQL Server Technical Article Authors : Denny Lee, Kay Unkroth Contributor : James Podgorski Technical Reviewers : Akshai Mirchandani, Murshed Zaman, T... Posted Jun 08 2010, 05:27 PM by denny.lee with | with 6 comment(s) Filed under: Performance, Analysis Services, Scale-Out

• High Performance SQL Server Workloads on Hyper-V

  Contributors: Lindsey Allen, Carl Rabeler, Arvind Rao, Mike Ruthruff, Arno Mihm Technical Reviewers: Prem Mehra,  Mike Weiner, Sung Hsueh, Madhan... Posted May 27 2010, 10:13 AM by Lindsey.allen with | with no comments Filed under: Performance, Analysis Services, Consolidation, Virtualization, SQL Server, SQL Server 2008

• Accelerating Microsoft adCenter with Microsoft SQL Server 2008 Analysis Services

  How Microsoft adCenter takes advantage of groundbreaking performance and scalability enhancements and innovative design tools available with Microsoft... Posted Sep 19 2009, 07:12 PM by denny.lee with | with 4 comment(s) Filed under: Performance, Analysis Services, SAN, Availability, Capacity, Optimization, design

• The Analysis Services 2008 Performance Guide

  SQL Server Techical Article Published: October 2008 Writer: Richrd Tkachuk and Thomas Kejser Technical Reviewers: T.K. Anand, Marius Dumitru, Greg Galloway... Posted Feb 15 2009, 11:49 AM by tkejser with | with 7 comment(s) Filed under: Performance, Analysis Services, Tuning

• Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques

  Brief Description This best practices white paper discusses three many-to-many query performance optimization techniques, including how to implement them... Posted May 03 2008, 03:29 PM by CarlRabeler with | with 2 comment(s) Filed under: Analysis Services

• 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... Posted Apr 17 2008, 05:40 PM by denny.lee with | with 6 comment(s) Filed under: Analysis Services, Distinct Count

• Scale-Out Querying with Analysis Services

  SQL Server Best Practices Article Published: June 13, 2007 Writers: Denny Lee, Nicholas Dritsas Contributors: Lubor Kollar, Lindsey Allen This white paper... Posted Dec 16 2007, 01:08 PM by denny.lee with | with 7 comment(s) Filed under: Analysis Services, Querying, Scalability

• Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services

  SQL Server Best Practices Article Published: August, 2007 Writers: Carl Rabeler, Eric Jacobsen Technical Reviewers: Craig Utley There are a variety of... Posted Dec 16 2007, 08:56 PM by admin with | with 1 comment(s) Filed under: Performance, Analysis Services, Querying

• Resolving Common Connectivity Issues in SQL Server 2005 Analysis Services Connectivity Scenarios

  SQL Server Best Practices Article Published: April 30, 2007 Writers : Carl Rabeler Technical Reviewers : Craig Utley This article identifies the top 10... Posted Dec 16 2007, 08:33 PM by admin with | with no comments Filed under: Analysis Services, Connectivity

• OLAP Design Best Practices for Analysis Services 2005

  SQL Server Best Practices Article Published: March 21, 2007 Writers: Matt Carroll Contributors: Robert Zare, Edward Melomed, Akshai Mirchandani, Marius... Posted Dec 16 2007, 08:25 PM by admin with | with no comments Filed under: Analysis Services, design

• Analysis Services 2005 Performance Guide

  SQL Server Best Practices Article Published: February 2007 Writers : Elizabeth Vitt Subject Matter Experts : T.K. Anand, Sasha (Alexander) Berger, Marius... Posted Nov 19 2007, 02:20 PM by admin with | with no comments Filed under: Performance, Analysis Services

• Scale-Out Querying with Analysis Services Using SAN Snapshots

  SQL Server Best Practices Article Published: September 2007 Writers : Carl Rabeler Contributors : Eric Jacobsen, Ron Talmage, Jon Danskin Technical Reviewers... Posted Nov 19 2007, 02:05 PM by admin with | with 5 comment(s) Filed under: Analysis Services, SAN, Querying, Scalability

• Precision Considerations for Analysis Services Users

  SQL Server Best Practices Article Published: September 2007 Writers : Denny Lee, Eric Jacobsen Contributors : Matt Burr, Chris Clayton Technical Reviewers... Posted Nov 19 2007, 05:52 AM by denny.lee with | with no comments Filed under: Analysis Services, Precision