dcsimg
 

Optimize T-SQL data types in SQL Server

Thursday Dec 6th 2007 by DatabaseJournal.com Staff

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

Home
Mobile Site | Full Site