▼
MSDN Library Visual Studio 6.0
▶
Welcome to the MSDN Library
▶
Visual Studio Documentation
▶
Visual Basic Documentation
▶
Visual C++ Documentation
▶
Visual FoxPro Documentation
▶
Visual InterDev Documentation
▶
Visual J++ Documentation
▶
Visual SourceSafe Documentation
▶
Tools and Technologies
▶
Microsoft Office Development
▼
Platform SDK
▶
What's New?
▶
Windows Programming Guidelines
▼
Database and Messaging Services
▶
DAO SDK
▶
Microsoft Data Access SDK
▶
Microsoft Exchange Server
▶
Messaging API (MAPI)
▶
Collaboration Data Objects
▶
Extending the Microsoft Exchange Client
▼
Microsoft SQL Server Programmer's Toolkit
▶
What's New in SQL Server 6.5
▶
SQL Server Setup
▼
Administrator's Companion
▶
Before You Begin
Part 1 Introduction
▶
Chapter 1 Overview
▶
Chapter 2 Introducing the SQL Distributed Management Framework
Part 2 Configuration
▶
Chapter 3 Configuring Servers
▶
Chapter 4 Configuring Clients
Part 3 Devices, Databases, and Drives
▶
Chapter 5 Managing Devices
▶
Chapter 6 Managing Databases
▶
Chapter 7 Managing Drives
Part 4 Security
▶
Chapter 8 Security Concepts
▶
Chapter 9 Managing Security
▶
Chapter 10 Remote Servers and Users
Part 5 Data Management
▶
Chapter 11 Exporting and Importing Data
▶
Chapter 12 Backing Up and Restoring
Part 6 Replication
▶
Chapter 13 Replication Concepts
▶
Chapter 14 Setting Up Replication
▶
Chapter 15 Advanced Replication
Part 7 Other Operations
▶
Chapter 16 Scheduling Tasks
▶
Chapter 17 Managing Alerts
▶
Chapter 18 Setting Up Mail
▶
Chapter 19 Monitoring Server Activity and Performance
Part 8 Troubleshooting
▶
Chapter 20 Troubleshooting Overview
▶
Chapter 21 Configuration Issues
▶
Chapter 22 Transaction Log Management
▶
Chapter 23 Understanding SHOWPLAN Output
▶
Chapter 24 Additional Problem-Solving Techniques
▶
Chapter 25 Handling Error Messages
Chapter 26 System Messages
▶
Chapter 27 DB-Library Error Messages
Chapter 28 ODBC Messages
Appendixes
▶
Appendix A Interoperation with Microsoft SQL Server 4.2
▼
Appendix B Estimating Database Size
▶
Calculating the Size of a Table with a Clustered Index
▼
Calculating the Size of a Nonclustered Index
Step 1: Calculate the Size of the Leaf Index Row
Step 2: Calculate the Number of Leaf Pages in the Index
Step 3: Calculate the Size of the Nonleaf Rows
Step 4: Calculate the Number of Nonleaf Pages
Step 5: Calculate the Total Number of Nonleaf Index Pages
Calculating the Size of a 9,000,000 Row Table with a Nonclustered Index
▼
Other Factors
Using a FILL FACTOR Value of 100 Percent
Using Different FILL FACTOR Values
Using Distribution Pages
Using Average Sizes for Variable Fields
Using Average Sizes for Very Small Rows
Using Average Sizes for text/image Data Pages
Appendix C System Tables Diagram
▶
Appendix D RAID Technology
▶
Appendix E Backup and Recovery Guidelines for Production Environments
▶
Appendix F Accessibility for People with Disabilities
▶
Database Developer's Companion
▶
Transact-SQL Reference
▶
Programming SQL Distributed Management Objects
▶
Guide to Microsoft Distributed Transaction Coordinator
▶
Programming ODBC for SQL Server
▶
Programming DB-Library for C
▶
Programming DB-Library for Visual Basic
▶
Programming Open Data Services
▶
Glossary 6.0
▶
Graphics and Multimedia Services
▶
Internet/Intranet/Extranet Services
▶
Networking and Distributed Services
▶
COM and ActiveX Object Services
▶
Setup and Systems Management Services
▶
User Interface Services
▶
Windows Base Services
▶
Reference
▶
SDK Documentation
▶
DDK Documentation
▶
Windows Resource Kits
▶
Specifications
▶
Knowledge Base
▶
Technical Articles
▶
Backgrounders
▶
Books
▶
Partial Books
▶
Periodicals
▶
Conference Papers