SQL Server for Developers, Fast Focus

SQT05 Fast Focus: SQL Server Data Types and Performance

11/15/2022

2:00pm - 2:20pm

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.

You will learn:

  • About inefficient datatypes
  • How to fix issues with datatypes
  • How to design better databases