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