[Video] Office Hours: Arctic Circle Puffins Edition

Erika and I are on the road in Iceland, roaming around the countryside, and I’m taking you with us. We visited Grímsey, a tiny island on the Arctic Circle, home to gazillions of sea birds like puffins and arctic terns. I took about half an hour to answer your most highly-voted questions from here:

Questions covered in the video:

00:00 Introductions 01:43 Should developers create indexes for their queries? 03:28 Do you recommend monitoring for resource-intensive queries? 04:40 How should I set max server memory? 07:30 How much free space in buffer pages is acceptable? 09:42 How can I