This week Microsoft released update 6 for Navision 4.0 SP3. Mainly a lot of SQL fixes, or so they say. At first I thought that it was a combination of update 1, 4 & 5 but that seems not to be the case. What they seem to have done is enable indexhints out of the box. This was already possible in older versions but it was by default disabled. Be aware that installing this update without profesional help can lead to very unexpected behaviour. It is indeed true that you can work around the SQL2005 bug with an index hint. But in the cases I have seen it usualy takes 4 or 5 to make the system work. The Microsoft solution can be a "little" overkill. The update comes without documentation but there is some. Please contact your local Microsoft hub or SQL Perform for more information. Still we need to put as much preasure as possible on Microsoft to keep working on better SQL support.
I cannot find this update in PartnerSource. Can anyone guide me to the right location? Thanks a lot in advance!
UPDATE: I have written a whitepaper about this subject.