Don't forget that you can also follow Sql Friday live on YouTube: Check out https://youtube.com/c/transmokopter/streams. Don't forget to follow the channel to get notifications when there's new content and new live-streams created on the channel.

When we are designing a database or table, we must choose a length for our character data types. Sometimes we don’t know how what the data will look like. When the column isn’t wide enough, we get an error when we insert or update data. So, to be on the safe side, we oversize the column. But this can have a big effect on 'Memory grants'. I'll explain what memory grant are and show the impact trough demos. We also look at the features that were introduce since SQL 2017 and how they will help us.