This resource is no longer available

Data type choices can have a significant impact on your database design and performance. A best practice is to “right-size” data types by asking business questions and determining the data types that are best suited to the organization’s needs.

Some of the ways that data type choices affect SQL include:

• The ability for DBAs to write more efficient code
• Unintended performance impacts, such as unnecessary page splitting
• The efficiency of an execution plan
• And more

Read this white paper to learn about all of the ways that data type choices can affect SQL Server database performance.

Vendor:

SentryOne LLC

Posted:

Feb 8, 2021

Published:

Nov 9, 2018

Format:

PDF

Type:

White Paper