Best simple sys operation controller tutorial https://stoneridgesoftware.com/batch-processing-in-dynamics-ax-2012-using-sysoperation-framework/
Business runtime functions https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/dev-ref/xpp-business-run-time-functions
Refresh AX Table recid sequence - https://stoneridgesoftware.com/microsoft-dynamics-ax-error-the-record-already-exists/
WHERE vs ON links in Dynamics AX - https://docs.microsoft.com/en-us/dynamicsax-2012/developer/how-to-use-the-queryfilter-class-with-outer-joins
Multiple lines for multiple headers - http://dev.goshoom.net/en/2013/11/lines-for-multiple-headers/
Change from iisexpress to iss - https://community.dynamics.com/blogs/post/?postid=4f987f63-3193-424f-b415-0c8253e026ff
Query tips: These are a few things I have found during my testing. If people see different results for these in their testing, please comment and I will update it.
1) Exists vs Inner Join - If the number of records on the parent table are over 1000, always use exist join when parent table is bigger than child table, but use inner join when child table is bigger than parent, as it ends up using the seek operation on the whole child table after cross product for exist join, but uses index when using Inner Join.
2) Always use the smallest table as the parent table when writing a query as that will make sure the join operations are performed based on the smallest (in terms of number of records) table in mind reducing the cross product to the smallest quantity.
Business runtime functions https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/dev-ref/xpp-business-run-time-functions
Refresh AX Table recid sequence - https://stoneridgesoftware.com/microsoft-dynamics-ax-error-the-record-already-exists/
WHERE vs ON links in Dynamics AX - https://docs.microsoft.com/en-us/dynamicsax-2012/developer/how-to-use-the-queryfilter-class-with-outer-joins
Multiple lines for multiple headers - http://dev.goshoom.net/en/2013/11/lines-for-multiple-headers/
Change from iisexpress to iss - https://community.dynamics.com/blogs/post/?postid=4f987f63-3193-424f-b415-0c8253e026ff
Query tips: These are a few things I have found during my testing. If people see different results for these in their testing, please comment and I will update it.
1) Exists vs Inner Join - If the number of records on the parent table are over 1000, always use exist join when parent table is bigger than child table, but use inner join when child table is bigger than parent, as it ends up using the seek operation on the whole child table after cross product for exist join, but uses index when using Inner Join.
2) Always use the smallest table as the parent table when writing a query as that will make sure the join operations are performed based on the smallest (in terms of number of records) table in mind reducing the cross product to the smallest quantity.
