INF: SQL Server 7.0 Storage Engine (White Paper) (322903)



The information in this article applies to:

  • Microsoft SQL Server 7.0

This article was previously published under Q322903

SUMMARY

The SQL Server 7.0 storage engine is designed to improve ease of use and to support customer applications well into the next century. For example, as the number of users and the quantity of data fluctuate, the storage engine can now reconfigure itself, adjusting space and memory as needed. It also supports lock enhancements, such as full and dynamic row-level locking.

To read a white paper that examines these and other improvements to the SQL Server 7.0 storage engine, please visit the following Microsoft Web site:

SQL Server 7.0 Storage Engine

Included in this document:
  • Storage Engine Architecture
  • Physical Database Organization
  • Lock Enhancements
  • Base Table and Index Architecture
  • Data-Type Enhancements
  • Log Manager Architecture
  • Memory Management

Modification Type:MajorLast Reviewed:5/29/2002
Keywords:kbinfo kbwhitepaper KB322903