SQL server 7.0 stretches

Abstract

The 2nd beta version of Microsoft Corp.'s SQL Server 7.0 is reviewed. Microsoft has implemented backward compatibility. The company has added an improved query processor, row-level locking, and expanding size limits. The query optimizer has been improved, and support has been added for distributed heterogeneous queries via ODBC and Microsoft's OLE DB interface. Support for row-level locking encompasses both data rows and index entries. This version of SQL Server works on everything from a notebook to a 16-processor symmetrical multiprocessor machine. Developers will like the improved Transact-SQL enhancements, the monitoring and debugging capabilities, and the integration with other Microsoft development tools, such as Visual C++.