| | Copyright |
| | About the Author |
| | Acknowledgments |
| | We Want to Hear from You! |
| | Reader Services |
| | Introduction |
| | | About the 70-431 Exam and Content Areas |
| | | How to Prepare for the Exam |
| | | What This Book Does |
| | | What This Book Does Not Do |
| | | About This Book |
| | Self Assessment |
| | | SQL Server Implementation and Maintenance as an MCTS |
| | Chapter 1. Installing and Configuring SQL Server 2005 |
| | | Installing and Configuring SQL Server 2005 |
| | | Exam Prep Questions |
| | Chapter 2. Creating Database Objects |
| | | Creating and Defining Databases |
| | | Defining SQL Server Tables |
| | | SQL Server Programmability Objects |
| | | Exam Prep Questions |
| | | Answers to Exam Prep Questions |
| | Chapter 3. Implementing Database Objects |
| | | Data Querying and Reporting |
| | | Data Querying Using Full-Text Indexes |
| | | Using System Tables and Views |
| | | Changing What Is Already Stored |
| | | Removing Unwanted Data |
| | | Exam Prep Questions |
| | | Answers to Exam Prep Questions |
| | Chapter 4. Supporting the XML Framework |
| | | Managing XML Data |
| | | Other SQL Server XML Support |
| | | Exam Prep Questions |
| | | Answers to Exam Prep Questions |
| | Chapter 5. Data Consumption and Throughput |
| | | Importing and Exporting Data |
| | | Implementing Service Broker |
| | | Exam Prep Questions |
| | | Answers to Exam Prep Questions |
| | Chapter 6. Database Maintenance |
| | | SQL Server 2005 Database Maintenance |
| | | Performing Database Backups |
| | | Restoring Data from a Backup |
| | | Using Database Snapshots |
| | | Automating Maintenance with Job Scheduling |
| | | Exam Prep Questions |
| | | Answers to Exam Prep Questions |
| | Chapter 7. Monitoring SQL Server Performance |
| | | SQL Server Management Studio |
| | | Monitoring and Recording Performance |
| | | Using Windows System Monitor |
| | | Using SQL Server Profiler |
| | | Exam Prep Questions |
| | | Answers to Exam Prep Questions |
| | Chapter 8. Troubleshooting and Optimizing SQL Server |
| | | Data Analysis and Problem Diagnosis |
| | | Tuning the Database Structure |
| | | Server Configuration Maintenance |
| | | Exam Prep Questions |
| | | Answers to Exam Prep Questions |
| | Chapter 9. Implementing High Availability |
| | | High-Availability Solutions |
| | | Using Replication |
| | | Microsoft Analysis Services |
| | | Exam Prep Questions |
| | | Answers to Exam Prep Questions |
| | Chapter 10. Practice Exam 1 |
| | | Exam Questions |
| | Chapter 11. Answers to Practice Exam 1 |
| | | Question 1 |
| | | Question 2 |
| | | Question 3 |
| | | Question 4 |
| | | Question 5 |
| | | Question 6 |
| | | Question 7 |
| | | Question 8 |
| | | Question 9 |
| | | Question 10 |
| | | Question 11 |
| | | Question 12 |
| | | Question 13 |
| | | Question 14 |
| | | Question 15 |
| | | Question 16 |
| | | Question 17 |
| | | Question 18 |
| | | Question 19 |
| | | Question 20 |
| | | Question 21 |
| | | Question 22 |
| | | Question 23 |
| | | Question 24 |
| | | Question 25 |
| | | Question 26 |
| | | Question 27 |
| | | Question 28 |
| | | Question 29 |
| | | Question 30 |
| | | Question 31 |
| | | Question 32 |
| | | Question 33 |
| | | Question 34 |
| | | Question 35 |
| | | Question 36 |
| | | Question 37 |
| | | Question 38 |
| | | Question 39 |
| | | Question 40 |
| | Chapter 12. Practice Exam 2 |
| | | Exam Questions |
| | Chapter 13. Answers to Practice Exam 2 |
| | | Question 1 |
| | | Question 2 |
| | | Question 3 |
| | | Question 4 |
| | | Question 5 |
| | | Question 6 |
| | | Question 7 |
| | | Question 8 |
| | | Question 9 |
| | | Question 10 |
| | | Question 11 |
| | | Question 12 |
| | | Question 13 |
| | | Question 14 |
| | | Question 15 |
| | | Question 16 |
| | | Question 17 |
| | | Question 18 |
| | | Question 19 |
| | | Question 20 |
| | | Question 21 |
| | | Question 22 |
| | | Question 23 |
| | | Question 24 |
| | | Question 25 |
| | | Question 26 |
| | | Question 27 |
| | | Question 28 |
| | | Question 29 |
| | | Question 30 |
| | | Question 31 |
| | | Question 32 |
| | | Question 33 |
| | | Question 34 |
| | | Question 35 |
| | | Question 36 |
| | | Question 37 |
| | | Question 38 |
| | | Question 39 |
| | | Question 40 |
| | Appendix A. Suggested Readings and Resources |
| | | Chapter 1: Installing and Configuring SQL Server 2005 |
| | | Chapter 2: Creating Database Objects |
| | | Chapter 3: Implementing Database Objects |
| | | Chapter 4: Supporting the XML Framework |
| | | Chapter 5: Data Consumption and Throughput |
| | | Chapter 6: Database Maintenance |
| | | Chapter 7: Monitoring SQL Server Performance |
| | | Chapter 8: Troubleshooting and Optimizing SQL Server |
| | | Chapter 9: Implementing High Availability |
| | Appendix B. Accessing Your Free MeasureUp Practice Test |
| | Appendix C. MeasureUp's Product Features |
| | | Multiple Testing Modes |
| | | Question Types |
| | | Random Questions and Order of Answers |
| | | Detailed Explanations of Correct and Incorrect Answers |
| | | Attention to Exam Objectives |
| | | Technical Support |
| | Glossary |
| | Index |