We’re going to look at index internals using pens rather than a computer. This means we’ll consider heaps v clustered indexes v non-clustered indexes, composite indexes, key choices (guid v int), page splits, fragmentation, as well as seeks and scans, sargability and residual predicates, and a bit on columnstore index internals too. It’s stuff I think all developers should know even if you’re not creating indexes, because it will impact your choices when you interact with your data.
Rob Farley does SQL & BI consulting through LobsterPot Solutions. He’s run the Adelaide Data & Analytics UG since 2005 and moonlights as Father Christmas and as a stand-up comedian. He’s an Microsoft Certified Master and Microsoft MVP. Reach him at firstname.lastname@example.org