Ms sql 2000 ebook

Internet Archive's 25th Anniversary Logo. Search icon An illustration of a magnifying glass. User icon An illustration of a person's head and chest. Sign up Log in. Web icon An illustration of a computer application window Wayback Machine Texts icon An illustration of an open book.

Books Video icon An illustration of two cells of a film strip. Video Audio icon An illustration of an audio speaker. Audio Software icon An illustration of a 3. Software Images icon An illustration of two photographs.

Images Donate icon An illustration of a heart shape Donate Ellipses icon An illustration of text ellipses. Registering a Server. Connecting to a Server. Disconnecting from a Server. Configuring SQL Server. Configuration Parameters. Advanced Configuration Parameters.

Configuration FAQ. Managing Databases. A Database Primer. Database Basics. Additional Database Information. Database FAQ. Managing Logins. Managing Server Roles. Managing Database Access and Database Roles.

Viewing and Modifying Login Information. Removing Logins. Changing a Password. Beyond Security Basics: Suggested Strategies. Backup and Recovery. Under the Covers. Creating a Backup Device. Understanding Log Truncation Options. Backup Wizard. Performing a Database Restore.

Restoring the master Database. Interactive Example of Losing and Restoring a Database. Creating a Backup Schedule. Log Shipping Overview. Backup and Restore FAQ. Areas of Maintenance. Maintenance Checklist. Maintenance FAQ. Automating Database Administration Tasks. SQL Server Agent. Database Maintenance Plan Wizard. Data Transformation Services. DTS and the Data Warehouse. The DTS Framework. Using the DTS Wizard. Using the DTS Designer. What Are Workflow and Batch Processing?

Using DTS Packages. BCP Syntax. Character Mode Versus Native Mode. Interactive BCP. Sample BCP Scripts. Modes of Operation. Common BCP Traps. BCP Tips. Troubleshooting SQL Server. SQL Error Messages. Deciphering the Error Log.

Using the Event Viewer. Killing a Process. Viewing Detailed Process Activity. Troubleshooting Applications. Other Sources of Help and Information. Using the Performance Monitor for Trend Analysis. Troubleshooting FAQ. Architecture Features. Multiple Database Instances. Federated Database Servers.

Other Enhancements. Database Design Issues. Understanding Indexes. General Principle Behind Indexes. Data Modification and Index Performance Considerations. How to Create Indexes. Other Index Operations. Suggested Index Strategies. Index FAQ. Query Optimization. What's a Query Optimizer? What Are Statistics? Basic Query Optimization Suggestions. Tools to Help Optimize a Query. Reading Showplans. Overriding the Optimizer.

Other Tuning Tricks. Query Optimization FAQ. Multiuser Issues. Multiuser Configuration Options. Multiuser FAQ. SQL Essentials. Distributed Queries.

Using Stored Procedures and Cursors. What Is a Stored Procedure? Stored Procedure Pros and Cons. How to Create a Stored Procedure. How to Modify a Stored Procedure. Control-of-Flow Language. Parameters Used with Stored Procedures. Commonly Used Global Variables. How to Debug a Stored Procedure. What Is a Cursor? Creating a Cursor. Putting It All Together. SQL Server and the Internet. Advanced Template File Example. XML Integration. Retrieving XML Data.

Updating Information via XML. Monitoring SQL Server. SQL Mail. Configuring SQL Mail. Using SQL Mail. Replication Overview and Terminology. Creating and Assigning the Distribution Database. Configuring Replication Distribution Options. Deleting a Distribution Database. Configuring Replication Publishing.

Enabling Replication Subscribers. Using the Disabling Publishing and Distribution Wizard. Replication FAQ. Transactional Replication. Applicable Uses for Transactional Replication. Replication Agents. Replication Topology. Immediate Updating Subscribers.