Monitoring, Maintaining, and Tuning, For Database Administrators, For IT Professionals

SQTH03 Database Design: Size DOES Matter

12/13/2012

8:00AM - 9:15AM

Level: Intermediate to Advanced

Thomas LaRock

Head Geek

SolarWinds

Great database performance starts with great database design. During the database design process it is important to select your datatypes wisely. The wrong choices will often lead to wasted space, increased response times, and less stability. Additionally you run the risk of having your design not scale as well as it should. Leave this session armed with the knowledge you need to help your databases perform at their peak efficiency.

You will learn:

  • How to choose the best performing datatypes
  • How to measure the effectiveness of the datatypes chosen
  • How to identify datatypes that can be adjusted