Stewart "Arturius" Campbell (7/17/2014)
Nice, straightforward one, thanks.
I have worked with numerous different RDBM's, and the page size is fixed in all of them.
Which in my mind begs the question of "Why?"
To cite another T-SQL RDBMS, Sybase's Advanced SQL Anywhere allows you to select the page size at database-creation time , with page size options up to 32KB. Obviously, bigger pages can have a significant impact on the I/O overhead, and Sybase's making it an option independent of the CPU type would seem to put the lie to claims of the restriction being necessary for "backward compatibility" with unnamed CPUs.