MCAD/MCSE/MCDBA 70-229 Exam Cram 2: Designing & Implementing Databases w/SQL Server 2000 Enterprise Edition

Terms you'll need to understand:

  • Concurrency

  • Lock

  • Index

  • Clustered index

  • Nonclustered index

  • Index Tuning Wizard (ITW)

  • Indexed view

  • UPDATE STATISTICS

  • Serializable

  • Database consistency checker (DBCC)

Techniques you'll need to master:

  • Working with transactions

  • Controlling locking

  • Creating, altering, and removing indexes

  • Performing system maintenance

    Related

    Категории