1. Home
  2. SQL
  3. Microsoft SQL Server 2000

Chapter 21. Administering Very Large SQL Server Databases

by Paul Jensen

IN THIS CHAPTER

  • Do I Have a Very Large Database (VLDB)?

  • VLDB Maintenance Issues

  • Partitioning Data

The realm of the very large database was once reserved for the mainframe environment and mega-corporations, but with the advent of fast, affordable processors and disks and database management software such as SQL Server 2000, large databases have proliferated as companies store huge amounts of data to assist in business analysis.

SQL Server 2000 was designed with the Very Large Database (VLDB) in mind, effectively scaling to support databases into the terabyte range.



    		Part I: Welcome to Microsoft SQL Server
    		Part II: SQL Server Tools and Utilities
    		Part III: SQL Server Administration
    		Chapter 8. Installing and Upgrading SQL Server
    		Chapter 9. Client Installation and Configuration
    		Chapter 10. SQL Server System and Database Administration
    		Chapter 11. Creating and Managing Databases
    		Chapter 12. Creating and Managing Tables in SQL Server
    		Chapter 13. Creating and Managing Indexes
    		Chapter 14. Implementing Data Integrity
    		Chapter 15. Security and User Administration
    		Chapter 16. Database Backup and Restore
    		Chapter 17. Database Maintenance
    		Chapter 18. SQL Server Scheduling and Notification
    		Chapter 19. Managing Linked and Remote Servers
    		Chapter 20. Importing and Exporting SQL Server Data Using BCP and DTS
    		Chapter 21. Administering Very Large SQL Server Databases
    		Do I Have a Very Large Database (VLDB)?
    		VLDB Maintenance Issues
    		Partitioning Data
    		Summary
    		Chapter 22. Data Replication
    		Chapter 23. SQL Mail
    		Chapter 24. SQL Server Clustering
    		Chapter 25. Defining System Administration and Naming Standards
    		Part IV: Transact-SQL
    		Part V: SQL Server Internals and Performance Tuning
    		Part VI: Additional SQL Server Features