Browse by Tags

• Aggregations
• ASLB
• Availability
• Cache
• Configuration
• Disaster Recovery
• Excel
• OLAP
• Partitions
• Performance
• Scalability
• SQL Server

• Excel, Cube Formulas, Analysis Services, Performance, Network Latency, and Connection Strings

  Author: Carl Rabeler Contributor: Josh Caplan Reviewers: Marius Dumitru, John Sirmon, Nick Medveditskov This technical note discusses the usage of three... Posted Jun 25 2010, 11:47 AM by CarlRabeler with | with 2 comment(s) Filed under: Analysis Services, Performance, OLAP, Excel

• Analysis Services Load Balancing Solution

  Author: Carl Rabeler Contributor: Josh Caplan Reviewers: Prem Mehra, Denny Lee, John Desch, Wayne Robertson, Steve Pontello, Thomas Kejser ASLB is a custom... Posted Feb 08 2010, 09:03 PM by CarlRabeler with | with 2 comment(s) Filed under: Analysis Services, Performance, Scalability, OLAP, ASLB

• Microsoft SQL Server 2008 Analysis Services Consolidation Best Practices

  Author: Carl Rabeler Contributor: Josh Caplan Reviewers: Prem Mehra, Denny Lee, John Desch, Wayne Robertson, Steve Pontello, Thomas Kejser This technical... Posted Feb 08 2010, 08:21 PM by CarlRabeler with | with 11 comment(s) Filed under: Analysis Services, Availability, Performance, Scalability, OLAP, SQL Server, Configuration, Disaster Recovery, ASLB

• Reintroducing Usage-Based Optimization in SQL Server 2008 Analysis Services

  Author : Denny Lee Contributors / Reviewers : Richard Tkachuk, Akshai Mirchandani, Robert Zare, Thomas Kejser, Gang Xiao, Cristian Petculescu Introduction... Posted Nov 18 2008, 06:09 PM by denny.lee with | with 6 comment(s) Filed under: Analysis Services, Aggregations, Performance

• Running Microsoft SQL Server 2008 Analysis Services on Windows Server 2008 vs. Windows Server 2003 and Memory Preallocation: Lessons Learned

  Author: Carl Rabeler Contributers: Eric Jacobsen, Thomas Kejser Technical Reviewers: Brad Daniels, Lindsey Allen, John Desch, Wayne Robertson, Kevin Cox... Posted Jul 16 2008, 12:56 PM by CarlRabeler with | with 18 comment(s) Filed under: Analysis Services, Performance

• Including Child Members Multiple Places in a Parent-Child Hierarchy

  Author: Carl Rabeler Contributor: Scott Hulke Reviewers: Richard Tkachuk, Thomas Kejser, Denny Lee When designing your SQL Server 2005 (or 2008) Analysis... Posted Mar 17 2008, 07:46 PM by CarlRabeler with | with 7 comment(s) Filed under: Analysis Services, Performance, OLAP

• Analysis Services Synchronization Best Practices

  Authors : Denny Lee, Edward Melomed, Mike Vovchik Contributors: Duy Vuong, Greg Washburn Reviewers : Prem Mehra, Stuart Ozer, Thomas Kejser, Nicholas Dritsas... Posted Mar 16 2008, 12:18 AM by denny.lee with | with 6 comment(s) Filed under: Analysis Services

• Analysis Services: Should you use many-to-many dimensions?

  Author: Denny Lee Reviewers: Mosha Pasumansky, Carl Rabeler, Richard Tkachuk Introduction For starters, please note that I am not saying not to use many... Posted Feb 11 2008, 02:29 AM by denny.lee with | with no comments Filed under: Analysis Services

• Sample Robocopy Script to customer synchronize Analysis Services databases

  Authors: Eric Jacobsen, Denny Lee Contributors: Mike Vovchik Technical Reviewers: Guillaume Fourrat, Richard Tkachuk, Thomas Kejser Applicable to: SQL... Posted Jan 17 2008, 02:51 PM by denny.lee with | with 17 comment(s) Filed under: Analysis Services, Scalability

• Analysis Services 2005 Aggregation Design Strategy

  Author: Eric Jacobsen, Denny Lee Introduction Designing effective aggregations are a well known way to improve query performance (for the sake of AS processing... Posted Sep 11 2007, 07:54 PM by admin with | with 2 comment(s) Filed under: Analysis Services, Aggregations

• How to warm up the Analysis Services data cache using Create Cache statement?

  Author: Eric Jacobsen, Christian Petculescu Updated by Denny Lee Goal This document describes how to build Create Cache commands. Create Cache for Analysis... Posted Sep 11 2007, 07:53 PM by admin with | with no comments Filed under: Analysis Services, Cache

• SSAS Partition Slicing

  Author: Eric Jacobsen Updated by Denny Lee Summary SSAS uses partitions to contain cube data. Small cubes might use only one, but for non trivial cubes... Posted Sep 11 2007, 07:45 PM by admin with | with no comments Filed under: Partitions, Analysis Services