SQL DownUnder CodeCamp 2007 – Analysis services

Session-13

Topic: Analysis Services Best Practices – Design, Storage, Queries and Calculations

Grant Paisley – SQL MVP – Angry Koala

Based on session DAT305 at TechEd 2007 (sessions by T K Anand and Christian Petculescu – Microsoft Corporation).

Talked about Muvee and Armadillo Run…great tools.

Started with importance of PERFORMANCE, how to get it:

Focus on Cube Design, Storage and Queries & Calculations.

Outlined Attribute relationship as the key to Good cube design, attribute relationships are used for storage, processing, query performance. Also discussed the best practices for Cube design. Thanks Grant Paisley.

October 15, 2007 · Rahul Desai · No Comments
Posted in: SQL Server, Tools, Tips & Utilities, UserGroups and conferences

Leave a Reply

You must be logged in to post a comment.