Self-Tuning Engine

SQL Server 7.0 dynamically allocates memory and disk space based on system resources and current workload. Devices that shrink dynamically are a feature that helps optimize resource use. Disk devices have been modified to become operating-system files, thus avoiding the overhead that SQL Server 6.5 imposes with database-specific devices.