How to Think Like the SQL Server Engine, Part 2: Nonclustered Indexes

That last module was horrible - it’s so much work when you only have a clustered index! In this module, you’ll get two nonclustered indexes, learn which one is more useful, and see why seek doesn’t mean awesome.