Monday, May 2, 2011

SQL temporary tables in AX 2012

In AX 2012 a new type of tables was introduced.

In addition to Regular (permanent) tables and InMemory tables (known as temporary tables in previous versions of AX) we have got TempDB tables - SQL server temporary tables.

I believe thit is the feature that many people expected for a long time. TempDB tables utilize the power of SQL tables - full support of joins, aggregation, indexes, all with great performance, but in the same time they have almost the same scoping mechanism as InMemory temporary tables have.
That simplifies developer's life significantly. There is no more need to be aware of tricks like this or like this.


  1. Please let me know if you're looking for a writer for your blog. You have some really great articles and I feel I would be a good asset. If you ever want to take some of the load off, I'd love to write
    some material for your blog in exchange for a link back to mine.

    Please shoot me an email if interested. Thanks!

    my website: calories burned walking calculator

  2. hello! To be honest, I didn't know about these functions and it's good to know it. Thanks a lot! I'm planning to introduce Microsoft Dynamics AX in my company ♥