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.

12 comments:

  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

    ReplyDelete
  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 ♥

    ReplyDelete
  3. Thanks for sharing an useful information we appreciate your valuable information and it usefulness.Sunbridge Software Solutions Pvt. Ltd. Is a Microsoft Dynamics partner practising more than decade has worldwide customer footprints. Microsot Dynamics 365 service provider in India. We offer Microsoft Dynamics AX, CRM and NAV making it your all-in-one Microsoft Dynamics 365 business edition partner Apart from providing the perfect software for your company, we also offer software implementation, support and training. Contact us: Email:info@sunbridgeindia.com, call us: +91(20) 22953290

    ReplyDelete
  4. you will get a custom sex doll because you can customizeダッチワイフ it to make your experience with her fun and memorable

    ReplyDelete
  5. Nice post thank you Robert

    ReplyDelete