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.