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.
To access the session recording, please login or register first:
Not a PASS member? Click here to register.
Senior Database Administrator, Ensono, LLC
Newly awarded Microsoft MVP, Andy Yun has been a Database Developer and Administrator for SQL Server for almost 15 years. Leveraging knowledge of SQL Server Internals and extensive experience in... View More