Every Byte Counts: Why Your Data Type Choices Matter

Andy Yun
60 minutes
Application & Database Development
Architect, Developer
200
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.
DBA or Developer background. Familiarity with database design principles. Working knowledge of CREATE TABLE & data types available in SQL Server.

View Recording

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

Sign In


Not a PASS member? Click here to register.

cage-aids
cage-aids
cage-aids
cage-aids