We explain query plan architecture and execution using an analogy of a home buyer, architect, builder, and supply store. We cover trivial query optimization, full optimization, and timeouts. Introductions (13 minutes) Lecture (43m) Demo Scripts Transact-SQL /* Mastering Query Tuning - How SQL Server Builds Query Plans This script is from our Mastering Query Tuning...
