Nov 26, 2023Read Committed Snapshot isolation and the Write Skew anomalyMuch has been said recently about the benefits of the Azure SQL for Business Central performance, and in particular a few articles...
Nov 14, 2023if not IsEmpty() then DeleteAll()My previous post on good and bad coding practices in terms of the performance touched upon one particularly contradictory coding pattern...
Nov 10, 2023Top 5 AL mistakes that undermine performanceThis post is my shortlist of the most common beginners' mistakes in AL that affect application performance. These are not necessarily the...
Jul 13, 2023When partial records and indexes reach synergyContinuing performance testing of queries on extended Business Central tables, today I want to look at the same dataset from a slightly...