DAX is super-fast, you can use it to query billions of rows in less than one second. End of marketing, now let’s go back to the real world. If your query is not performing as advertised, it is time to dive into the details of optimizations, which means catching the query plan with the profiler, understanding what is happening under the cover and rephrase your query, or re-shape your model so to obtain better performance. In this live demo session, Alberto will start with a simple query and he will perform on stage all the necessary steps to optimize it, showing you the tools ant the techniques used to identify the bottleneck and to fix the performance issues. In the meantime, there will be chances to dive into some of the internals of the xVelocity query engine to  grab a better understanding of the optimization techniques in DAX.
Presented by Alberto Ferrari at SQLBits XII
Slide deck 4.3 MB
MP4 Video HD 558 MB