EXAM CRAM™ 2 Designing and Implementing Databases with SQL Server 2000 Enterprise Edition [Electronic resources] نسخه متنی

Chapter 8. Designing for Optimized Data Access

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