Hugo Kornelis (1/20/2012)
Sounds plausible. Pages do have a page number.
(Though I don't understand why MS would choose to use a signed integer to store page numbers; it's not as if there will ever be negative page numbers!)
Well, they seem to use one for the file number too--that 32767 you mentioned earlier is the maximum possible value for a SIGNED 16-bit integer; 32-bit would go up to 65535!
I assume you meant to write that SIGNED 16-bit goes up to 32767 and UNSIGNED 16-bit goes up to 65535. 32 bits goes quite a bit further!
And you are right, that had occurred to me as well. Apparently, MS decided to use signed integers for both page and file numbers. Maybe it never occured to them that people would want more than 16 TB in a file, or more then 32,767 files. Or maybe there is some performance advantage of using signed versus unsigned integers?
(Would you believe, after all of this discussion, that my largest database is 500 MB in size and lives on my laptop?)