SQL Server 7 : the complete reference /
Gayle Coffman
- Berkeley, California : Osborne/McGraw-Hill, c1999.
- xliii, 912 pages : illustrations ; 23 cm.
- Database professional's library. .
Includes index.
1. What Is Microsoft SQL Server? -- 2. Improvements in Capacity -- 3. Microsoft Management Console -- 4. SQL Server Agent -- 5. Integration with Windows NT Security -- 6. Transact-SQL Enhancements -- 7. New and Enhanced Tools -- 8. Utility Changes -- 9. Replication Enhancements for SQL Server 7 -- 10. Simplifying the Role of the Database Administrator -- 11. Installing SQL Server -- 12. Installing SQL Mail -- 13. Upgrading SQL Server -- 14. Database Management -- 15. Preventive Maintenance of Databases -- 16. Linked Servers and Remote Servers -- 17. Tools to Monitor Server Performance -- 18. Development Topics -- 19. Using Transact-SQL -- 20. Data Warehouses and the Data Marts -- 21. Transact-SQL Programming Language Reference -- 22. System Tables -- 23. System Stored Procedures -- A. Pre-installation Preparation Checklist.
Now with row-level locking, auto-grow databases, terabyte capability, and the most powerful I/O and administration toolset ever, SQL is the database for the next century! The SQL Server skill set is in high demand - and whether you're an experienced DBA or just starting out, this complete reference teaches you everything you need to know to install and use SQL Server 7.