Appropriately sized datatypes are going to be crucial for running SQL queries efficiently. If you don’t want your database to be full of 💩 and other emojis you’ll want to put down the nvarchar(max). When SQL Server sees your query is using column with a max datatype, it wants to allocate 4KB of RAM per row, and that’s going to add up quick. On top of that, you can’t index a max column. How about before adding max columns, just, think twice.
