SQL Server 2000

SQL Server 2000 has many powerful features to support international operations and environments. It is full-fledged Relational Database Management System. SQL Server 2000 is that the database engine has become largely implemented all over the world because of the below listed convincing features.

• Self-configuring
• Self-tuning
• Self-managing.
• Automatic tune free buffers
• Automatically tunes the recovery interval option
• Manages its own log cache
• Monitor disk I/O subsystem performance
• Application and Query Tuning
• Improvement in Performance
• Complete row-level locking
• Scalable storage, including VLDB support
• Improved text and image support
• Client-Server Technology
• Different Security mode e.g. Windows NT, Mixed mode