21
Are the 8000 and 4000 character limits on variable-length columns down to the page size?
In SQL Server, a non max variable length column can hold up to 8000 characters for the single byte type and 4000 for the double byte type. A page is 8 kilobytes, which is 8192 bytes. The correspondence is close enough…