Understanding the tables cardinality concept

As a trainer, I am often asked the question how to set the Relation’s properties in a table’s relations node, and how / where are those used, so, this would not necessarily be a new topic but rather a review of the concept:

Getting the Internal size of the records message

This has been briefly discussed before but for the newcomers to the AX world if you are getting this error: "The total, internal size of the records in your joined SELECT statement is [x] bytes, but Microsoft Dynamics is by default performance-tuned not to exceed 49152 bytes" it means one thing:

Reset SQL Server name after VM cloning

If you're reading this, I bet that you are working heavily with VMs, and like in my case, they are cloned from a base machine. The base machine that I am cloning has already SQL Server installed on it. Today I stumbled across a problem that made me realize that I still have some settings to change after cloning.