SQL Server Performance Tuning and Optimization

SQW02 Database Design: SQL Server Datatypes

11/15/2023

8:00am - 9:15am

Level: Introductory to 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:

  • About datatypes
  • About choosing correct datatypes
  • How to fix bad decisions