SQLBits 2010
Analysis Services Best Practices
Some tips and tricks which I have picked in my last few projects which can help you optimize cube design , optimize query and processing performance .
This session contains tips and tricks for modelling a high performance cube both in terms of processing and querying. I will demonstrate how attribute relationships play a crucial role in a cube design , why are hierachies important , how to make sure aggregations are used efficiently and many more tips around dimensional modelling , AS server configuration etc .
Expect loads of demos and real life examples.