Indexing on Index Cards
This is part 1 of a series to help people better understand storage, caching, and ultimately indexing in SQL Server. The concepts are applicable to any modern relational database, and most non-relational databases. This video covers caching, logical and physical IO, dirty pages, and checkpointing.