Brent, Big Coat Edition
You’ve watched my free How to Think Like the Engine class that focuses on the small 1GB Users table.
Let’s take things up a notch by using the ~164GB Posts table full of questions & answers. You’ll learn:
What PAGEIOLATCH waits are Why you can’t usually fix them by just adding small amounts of memory like 16-64GB RAM Why key lookups aren’t a big deal (compared to the alternative) Why SELECT * isn’t as bad as it’s cracked up to be Why big data also means slow writes on storage
Join me next Thursday