The following chart shows new table object limits for the different page sizes, with some differences according to locking scheme. This is for your information only. For more information on creating tables, see the Transact-SQL User’s Guide
User-visible object (sizes in bytes) |
2K logical page |
4K logical page |
8K logical page |
16K logical page |
|---|---|---|---|---|
Number of rows per page |
APL=256 DOL=166 |
APL=256 DOL=337 |
APL=256 DOL=678 |
APL=256 DOL=1361 |
Row length |
APL=1960 DOL=1958 |
APL=4008 DOL=4006 |
APL=8104 DOL=8102 |
APL=16296 DOL=16294 |
Fixed-length column |
APL=1960 DOL=1958 |
APL=4008 DOL=4006 |
APL=8104 DOL=8102 |
APL=16296 DOL=16294 |
Variable-length column |
APL=1947 DOL=1952 |
APL=3987 DOL=4000 |
APL=8067 DOL=8096 |
APL=16227 DOL=16288 |
Size of index key |
APL=600 DOL=600 |
APL=1250 DOL=1250 |
APL=2600 DOL=2600 |
APL=5300 DOL=5300 |
