Optimize T-SQL data types in SQL Server

Wednesday Dec 5th 2007 by DatabaseJournal.com Staff
Share:

This article looks at the various SQL Server data types, the effects they have on performance, and what you should consider when choosing a data type.

[From SearchSQLServer]

Many SQL Server developers do not give data types a lot of thought when they design database schemas. Initially it doesn't seem to matter much and the performance looks pretty good, but, over time, the system slows down. Let's take a look at the various SQL Server data types, the effects they have on performance, and what you should consider when choosing a data type.

The article continues at http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1284636,00.html

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved