| About the Contributors | p. v |
| Acknowledgments | p. vii |
| Preface | p. xv |
| Introduction | p. xvii |
| Installing SQL Server 2000 | p. 1 |
| Installing SQL Server | p. 2 |
| Questions | p. 3 |
| Failover Clustering | p. 4 |
| Questions | p. 6 |
| Default Collation | p. 8 |
| Questions | p. 10 |
| Number of Instances | p. 11 |
| Questions | p. 12 |
| File Location | p. 13 |
| Questions | p. 14 |
| Service Account | p. 15 |
| Questions | p. 17 |
| Performing a Custom Upgrade to SQL Server 2000 | p. 18 |
| Questions | p. 18 |
| Upgrading to SQL Server 2000 from SQL Server 6.5 | p. 19 |
| Questions | p. 20 |
| Upgrading to SQL Server 2000 from SQL Server 7.0 | p. 21 |
| Questions | p. 22 |
| Lab Question | p. 24 |
| Quick Answer Key | p. 25 |
| In-Depth Answers | p. 26 |
| Lab Answer | p. 36 |
| Configuring SQL Server 2000 | p. 39 |
| Creating a Linked Server | p. 40 |
| Questions | p. 44 |
| Configuring SQL Mail and SQL Agent Mail | p. 45 |
| Questions | p. 47 |
| Configuring Network Libraries | p. 49 |
| Questions | p. 51 |
| Troubleshooting Failed Installations | p. 52 |
| Questions | p. 55 |
| Lab Question | p. 57 |
| Quick Answer Key | p. 59 |
| In-Depth Answers | p. 60 |
| Lab Answer | p. 69 |
| Creating SQL 2000 Databases | p. 71 |
| Creating and Altering Databases | p. 72 |
| Questions | p. 76 |
| Setting Database Options | p. 78 |
| Questions | p. 81 |
| Adding/Configuring Filegroups | p. 83 |
| Questions | p. 86 |
| Expanding and Shrinking Databases | p. 87 |
| Questions | p. 89 |
| Sizing and Placing the Transaction Log | p. 91 |
| Questions | p. 92 |
| Configuring Database Options for Performance | p. 95 |
| Questions | p. 97 |
| Attaching and Detaching Databases | p. 99 |
| Questions | p. 101 |
| Lab Question | p. 103 |
| Quick Answer Key | p. 105 |
| In-Depth Answers | p. 106 |
| Lab Answer | p. 116 |
| Creating and Managing Database Objects | p. 119 |
| Creating and Managing Basic Database Objects | p. 120 |
| Creating and Managing Constraints | p. 122 |
| Questions | p. 125 |
| Creating and Managing Indexes | p. 126 |
| Questions | p. 131 |
| Creating and Managing Stored Procedures | p. 132 |
| Questions | p. 134 |
| Creating and Managing Triggers | p. 135 |
| Questions | p. 136 |
| Creating and Managing Views | p. 137 |
| Questions | p. 139 |
| Lab Question | p. 141 |
| Quick Answer Key | p. 143 |
| In-Depth Answers | p. 144 |
| Lab Answer | p. 149 |
| Managing, Monitoring, and Troubleshooting SQL Server 2000 Databases | p. 151 |
| Optimizing Database Performance | p. 152 |
| Questions | p. 159 |
| Optimizing Data Storage | p. 162 |
| Questions | p. 164 |
| Managing Database Schema | p. 165 |
| Questions | p. 168 |
| Lab Question | p. 170 |
| Quick Answer Key | p. 171 |
| In-Depth Answers | p. 172 |
| Lab Answer | p. 175 |
| Backing Up, Restoring, and Recovering SQL 2000 Databases | p. 177 |
| Recovering System State | p. 178 |
| Questions | p. 181 |
| Backing Up User Databases | p. 182 |
| Questions | p. 187 |
| Backing Up System Databases | p. 189 |
| Questions | p. 191 |
| Restoring User Databases | p. 192 |
| Questions | p. 199 |
| Restoring System Databases | p. 202 |
| Questions | p. 204 |
| Configuring, Maintaining, and Troubleshooting Log Shipping | p. 205 |
| Questions | p. 207 |
| Performing Integrity Checks | p. 208 |
| Questions | p. 212 |
| Troubleshooting Transactions and Locking | p. 212 |
| Questions | p. 215 |
| Lab Question | p. 216 |
| Quick Answer Key | p. 217 |
| In-Depth Answers | p. 218 |
| Lab Answer | p. 227 |
| Extracting and Transforming Data with SQL Server 2000 | p. 229 |
| Using XML Support | p. 230 |
| Questions | p. 234 |
| Importing and Exporting Data with Data Transformation Services | p. 235 |
| Questions | p. 238 |
| Developing and Managing DTS Packages | p. 240 |
| Questions | p. 242 |
| Managing Linked Servers | p. 244 |
| Questions | p. 246 |
| Converting Data Types | p. 247 |
| Questions | p. 249 |
| Configuring, Maintaining, and Troubleshooting Replication Services | p. 251 |
| Questions | p. 254 |
| Lab Question | p. 255 |
| Quick Answer Key | p. 256 |
| In-Depth Answers | p. 257 |
| Lab Answer | p. 262 |
| Managing and Monitoring SQL Server 2000 Security | p. 263 |
| Configuring Security Modes | p. 264 |
| Questions | p. 266 |
| Creating and Managing Logons | p. 267 |
| Questions | p. 271 |
| Creating and Managing Database User Accounts | p. 273 |
| Questions | p. 274 |
| Adding and Removing Users from Fixed Roles | p. 276 |
| Questions | p. 280 |
| Creating Roles to Manage Database Security | p. 281 |
| Questions | p. 284 |
| Setting Permissions in a Database | p. 286 |
| Questions | p. 289 |
| Enforcing and Managing Security by Using Stored Procedures, Triggers, Views, and User-Defined Functions | p. 291 |
| Questions | p. 294 |
| Managing Security Auditing | p. 296 |
| Questions | p. 298 |
| Lab Question | p. 300 |
| Quick Answer Key | p. 302 |
| In-Depth Answers | p. 303 |
| Lab Answer | p. 311 |
| Managing SQL Server 2000 Automation | p. 315 |
| Creating, Managing, and Troubleshooting SQL Server Agent Jobs | p. 316 |
| Questions | p. 321 |
| Configuring Alerts Using SQL Server Agent | p. 322 |
| Questions | p. 326 |
| Creating and Using User-Defined Event Messages | p. 328 |
| Questions | p. 330 |
| Configuring Operators | p. 332 |
| Questions | p. 333 |
| Lab Question | p. 335 |
| Quick Answer Key | p. 336 |
| In-Depth Answers | p. 337 |
| Lab Answer | p. 342 |
| Managing, Monitoring, and Troubleshooting SQL Server 2000 | p. 343 |
| Optimizing Hardware Resources | p. 344 |
| Questions | p. 347 |
| Monitoring Hardware Using System Monitor | p. 350 |
| Questions | p. 352 |
| Resolving System Bottlenecks by Using System Monitor | p. 354 |
| Questions | p. 356 |
| Optimizing and Troubleshooting SQL Server System Activity Using the Profiler | p. 357 |
| Questions | p. 359 |
| Lab Question | p. 361 |
| Quick Answer Key | p. 362 |
| In-Depth Answers | p. 363 |
| Lab Answer | p. 368 |
| Practice Exam | p. 369 |
| Questions | p. 370 |
| Answers | p. 395 |
| Glossary | p. 417 |
| Table of Contents provided by Syndetics. All Rights Reserved. |
