Improved I/O

SQL Server 7.0 has enhanced I/O capability in database page size. Page size has been increased from 2 KB to 8 KB, with a maximum of 8,060 bytes per row. Other enhancements change the character data type limit from 255 bytes to 8,000 bytes and the columns per table limit from 250 columns to 1,024 columns. These changes allow SQL Server to handle much larger databases.