I’ve been asked to reiterate some arguments against direct access to AX business data. (As you all know, the recommended approach is always going through AOS, such us calling web services.) Here are some of the arguments: You would bypass all business logic. It often means that you would have to re-implement some AX logic …
I love this quote: 🙂 We were treating SQL Server as a relational database. What I learned is that it’s really not. It’s a software abstraction layer over disk I/O. If you don’t know what’s happening at the disk I/O layer, you don’t know anything. (Brian Harry about TFS scaling)
You sometimes need to connect from Dynamics AX to another database and read or write data there. The usual approach uses OdbcConnection class, as described on MSDN in How to: Connect to an External Database from X++ Code [AX 2012]. Although it definitely is a possible solution (I used it already in AX 3.0), it …
Included columns is a feature of SQL Server (since version 2005) related to indices.Thanks to it you can attach additional fields to an index that are not used for searching (so they don’t have to be maintained so expensively) but that can be used by database server to return data. If all columns being returned …
Included columns* je schopnost SQL Serveru (od verze 2005) týkající se indexů. Díky ní můžete připojit k indexu další sloupce, které nejsou používány pro vyhledávání (takže se nemusí tak nákladně udržovat), ale které může databáze použít pro vrácení dat. Pokud jsou všechny sloupce vracené dotazem zahrnuty v indexu, databázový server může rovnout vrátit data a …