Every Byte Counts: Why Your Data Type Choices Matter

Speaker(s)Andy Yun 

Duration: 60 minutes

Track: Application & Database Development

Ever encounter a table consisting only of BIGINT, CHAR(255), and NVARCHAR(MAX) columns? Did your gut tell you that this is bad, but you had difficulty explaining why? Did you know that these data type choices can be a real performance killer? Attend this session to learn how database records are stored within SQL Server, and why all data types are not created equal. Armed with that knowledge, we will then explore several performance scenarios that may be impacting your systems right now! When you leave, you will be able to explain to your colleagues why data type choices matter, assess your own systems, and implement some best practices to mitigate these performance killers.


View Recording

To access the session recording, please login or register first:

Sign In


Not a PASS member? Click here to register.