🚧 📱

Mobile experience coming soon

Mobile development is in progress. Until it is complete, please use your desktop or laptop.

Thanks!

← Back
IAmTimCorey May 26, 2025

The Dangers of nvarchar(max) in SQL for Entity Framework Developers

Summary

The main theme is the critical importance of understanding SQL basics, particularly when using ORMs like Entity Framework, to avoid performance issues. The transcript highlights the default behavior of Entity Framework creating NVARCHAR(MAX) string fields and contrasts it with specifying proper lengths, demonstrating how seemingly small SQL choices can lead to significant database performance degradation. The practical takeaway is that developers must actively manage their SQL database schema and understand its implications, rather than relying solely on ORM defaults, to prevent slow applications.

View original episode ↗