Page size vs. record size

genericgeneric Member Posts: 511
edited 2015-01-26 in SQL General

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?



  • davmac1davmac1 Member Posts: 1,279
    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.
Sign In or Register to comment.