If you have any Analysis Services cube, you'll know how important it is to properly design, set up and tune the cube.  This session explains how to appropriately deal with dimension design and hierarchy relationships, cube partitioning, how to deal with many-to-many relationships and how to design aggregations which take advantage of all the design decisions you've made in order to wring out every last drop of performance from your cube.

Inspired by a recent journey to the shores of a one terabyte cube, the session includes code demonstrations as well as lots of practical tips which you can take away and put into real-life usage.

Presented by Duncan Sutcliffe at SQLBits VIII
.zip 18 MB
MP4 Video Med 109 MB
MP4 Video HD 413 MB