Making the right data type choices for your SQL server database

How your Data Type Choices can Affect SQL Server Database Performance

Cover

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:
09 Nov 2018
Published:
09 Nov 2018
Format:
PDF
Length:
13 Page(s)
Type:
White Paper
Language:
English
Already a Bitpipe member? Login here

Download this White Paper!