Every Byte Counts - Why Your Data Type Choices Matter

Explore the critical impact of data type choices on SQL Server performance in this 52-minute conference talk from PASS Data Community Summit. Discover how database records are stored within SQL Server and why all data types are not created equal. Learn to identify and explain common pitfalls, such as tables consisting only of BIGINT, CHAR(255), and NVARCHAR(MAX) columns. Gain insights into various performance scenarios that may be affecting your systems and acquire the knowledge to assess your own databases. Walk away with the ability to articulate the importance of proper data type selection to colleagues and implement best practices to mitigate performance issues. Speaker Andy Yun provides valuable expertise to help you optimize your SQL Server databases and avoid common data type-related performance killers.

24 Hours of PASS: Every Byte Counts Why Your Data Type Choices Matter