The maximum size of a table row in SQL Server in limited to 8 KB, or to be more precise 8060 bytes, if we follow Microsoft online articles, such as Maximum Capacity Specifications for SQL Server - SQL Server | Microsoft Learn . This limit arises from the SQL Server data storage architecture: table rows are organized in 8-kilobyte pages, and a single row cannot exceed the size of the page, therefore 8KB is the maximum amount of storage space that can be allocated for a single

I once wrote a post on event subscribers and the presumed performance benefits of single instance subscriber codeunits, but the topic keeps reappearing every now and then, and I feel it could be a good idea to add a few more arguments to the same old debate. Because why not run a few useless, but highly entertaining tests on a Saturday evening. One statement in defense of the single instance event subscribers is that the subscriber codeunit does not have to be disposed after

Recently I heard an opinion shared by some AL developers that recursion in AL can be dangerous and should be avoided because the AL...

Recently I was debugging a very interesting deadlock case which I want to share in a blog post now. It was especially curious because, as...

Following my series of posts where I have been addressing various aspects of table indexing, this post delves into the same old argument...

When we declare multiple instances of a record variable referencing the same table in AL code, we essentially receive different instances...

Development of Business Central extensions is very much about the database communication, and as AL developers, we always control the...

Yes, I'm back again on this inexhaustible topic. The question of weather the call of IsEmpty before FindSet in AL can have a positive...

In two of my previous blog posts I reviewed some pros and cons of the SumIndexField Technology (or SIFT) in Business Central. On the one...

SIFT, which stands for Sum Index Flow Technology, used to be a know-how in the Navision database, a data structure that stored...

RecordLevelLocking function in AL is a heritage of the C/SIDE times and the Navision native database. In those old days when Navision...

A long time ago (in a galaxy far away) I published some blog posts with a deeper overview of the Business Central's ReadIsolation...

This almost detective story started when I was building a client app in Business Central which sent data to a JavaScript control add-in...