Data Management

DPW03 Database Design: SQL Server Datatypes

11/20/2024

9:30am - 10:45am

Level: Intermediate

Thomas LaRock

Manager, Data Engineering

BlackLine

Great database performance starts with great database design. During the design process it is important to select your SQL Server datatypes wisely. Failure to do so will result in wasted disk space, additional I/O overhead, and decreased performance. There is also the risk that your design will not scale as well as it should. Unless you have unlimited hardware purchasing power, size matters.

Attend this session and learn how smart, effective database design will ensure your databases perform at their peak efficiency. You will learn how to choose the best performing datatypes, how to measure their effectiveness, and how to correct bad datatypes decisions (decision that were not, of course, made by you.)

You will learn:

  • Understand datatypes
  • Choosing correct datatypes
  • Fixing bad decisions