How to Think Like the Engine Part 2

As we continue to learn how SQL Server works, we'll add in nonclustered indexes and explain the differences between seeks and scans.