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