Data Types & Normalization To optimize performance you must understand how to properly design your SQL Server 2016 database. Examine database normalization and the various data types available in SQL Server 2016.