Fulltext Index

How to use the Fulltext Index

Database checklist – written by the AX Performance Team

Excerpt:
Some time ago, on the AX Performance Team Blog 2 posts “Ax Database Configuration Checklist” were published.
Not up-to-date, but the basics are still relevant for the current versions (of AX and SQL-Server).

the secrets of the datatype STR

How long is a string and how much chars could it hold? And the memo Datatype?
How acts the AX kernel when a str 8000 is defined? and when using an extended datatype ?
And whats about the database? using these definitions as a table-field?
The secrets of the datatype str !! read the solution!