[Video] Office Hours on the Balcony Part 2


Picking up right where we left off yesterday, we continue down through the not-so-highly-upvoted questions from https://pollgab.com/room/brento.

Here’s what we covered:

00:00 Introductions 00:22 Andrew from Canada: To Null or not to Null? That is the question. On tables with 100M to 1B rows and with several columns that contain data 20% of the time, should we still allow nulls or set them to an empty/zero value instead? If it’s just retuned but not queried, does that matter? 02:02 FARAN: Hi Brent, is separating MDF and LDF on different physical drive still needed when we use SSD? 04:34 Maciej: Hi