Alberto is a Business Intelligence consultant. His main interests are in two areas: methodological approach to the BI development lifecycle and performance tuning of ETL and SQL code. His activities are related to designing and implementing solutions based on Integration Services and Analysis Services for the financial, manufacturing and statistical areas. He is also a book author and a speaker in international conferences like PASS Summit, SQLRally and SQLBits.
DAX as a Query Language
- Stopnja 300
24. april 2013 13:45
In SQL 2012 DAX became a query language and, when it comes to performance, the xVelocity in-memory engine is second to none. Scanning fact tables and performing leaf-level computation happens in a matter of milliseconds. Nevertheless, as with any other language, you can write good DAX or bad DAX, depending on your understanding of the engine internals. In this session we are going to introduce DAX as a query language, showing the different ways of querying with DAX using real-world data. Some queries will be fast, others will need optimizations and a better understanding of query plans, which we will show, in order to give a complete understanding of how to get the best out of DAX.