Table indexes and inserts
Another alternative to SIFT: Columnstore indexes
Hidden SQL queries in AL you (probably) want to avoid
if not IsEmpty then FindSet... again
Covering indexes as an alternative to SIFT
if not IsEmpty then FindSet... Or not?
The dark side of SumIndexFields. Concurrency.
SIFT
Navision legacy in AL: RecordLevelLocking
Select with partially matching index: can we make it faster?
Lock timeouts and deadlocks
Read Committed Snapshot isolation and the Write Skew anomaly
if not IsEmpty() then DeleteAll()
Top 5 AL mistakes that undermine performance
When partial records and indexes reach synergy
Who benefits from partial records: The true magic of SetLoadFields
Locking Scope: Differences between LockTable and ReadIsolation
Introduction to Business Central Caching - Part 2
Test assertions on DateTime values
ReadCommitted isolation in Azure SQL