SQL Server Customer Advisory Team - SQL Server Best Practices

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

Technical Notes

Browse by Tags

All Tags » Aggregations » Analysis Services (RSS)

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 no comments

Filed under: Analysis Services, Aggregations, Performance, Featured

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

sql, server, best practices, whitepapers, analysis services, data mining, olap, datawarehouse, datawarehousing, availability, clustering, capacity, collation, data types, data warehouse, database, design, index, mirroring, optimization, partitions, performance, precision, processing, querying, scalability, security, reporting services, integration services