SQL Server 7.0/2000:

SQL Server 2000 Enterprise Edition on the Windows 2000 DataCenter can support up to 32 CPU and up to 64GB physical memory (RAM) on a computer!

How Fast Is Fast? SQL Server 2000 can handle 709,220 transactions per minute! SQL Server 2000 has further established its position as the fastest database in the world. With a performance rating of 709,220 transactions per minute (tpmC) and price/tpmC of $14.96 US, a 32-node Compaq ProLiant DL760-900-256P system exceeded the previous record, which was also held by SQL Server 2000.

Another benchmark test demonstrated support for 25,200 simulated concurrent users and performed CRM transactions at the rate of 2,024 business processes per minute. These results were achieved on a 24-processor Unisys ES7000 database server and yielded average response times between one and two seconds.

How do I convert an .MDB to SQL Server?

For Access 97: The Access Upsizing Wizard Free download:

http://www.microsoft.com/accessdev/prodinfo/aut97dat.htm

The Access Upsizing Wizard preserves database structure including data, indexes, defaults, and so on, and automatically converts Access validation rules and defaults to the appropriate SQL Server equivalents. It also maintains table relationships and referential integrity after upsizing.

For Access 2000: (Upgrading to an .ADP file) The upsizing wizard is built in to the Access runtime. You can choose to create an .MDB with SQL Server tables linked, or to an .ADP file. Provides all the functionality of the Access 97 upsizing wizard.

The table below the book resources displays the general SQL Server 97/2000 characteristics:

Some SQL book resources: