Database Internals - Important information for performance, with Rob Farley

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.

About Rob

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 r[ob@lobsterpot.com.au](mailto:ob@lobsterpot.com.au)

Thanks to Encode Talent and Taptu!

This is an in-person event.