Page size vs. record size

generic

Hello.

In NAV the max record size is 8000 bytes and the size of a page is 8KB on sql server.
Can I conclude then that if sql places a page lock that then only one record will be locked?

Thanks.

davmac1

This is the max. record size. If the record size is smaller - which it is in most cases, you will have multiple records in a page. A prominent example of this is the no. series table.
For small tables (low record count), you can get around this by either creating filler rows - which may not make the users happy - or adding filler characters (see Jorg Stryk blog /presentation) for example.