Optimize T-SQL data types in SQL Server

To optimize Transact SQL (T-SQL) data types in SQL Server, learn how each type affects performance -- I/O, RAM and CPU in SQL Server.

Default Character Cast

Reverse Engineering ADTs in SQL Server 2000 - Part 3

Continuing on with his series on ADTs, Yakov Shlafman takes a look at working with schema changes when your ADT is on a column used as a primary or foreign key.

Reverse Engineering Alias Data Types in SQL Server 2000

In SQL Server 2005 there is the concept of alias data types, which are similar to user-defined data types in SQL Server 2000. Yakov Shlafman brings us the first part of a series looking at these structures in SQL Server 2000.

Unique Identifier: Usage and Limitations

The Unique Identifier datatype in SQL Server has tremendous potential to solve many of the issues one finds with Identity fields, other primary keys, etc. However it also has some drawbacks and limitations. Author Sharad Nandwani looks at some of the pros and cons of this datatype.

Brief Tutorial on Text, Ntext, and Image

Joseph has written a couple articles for us and forwarded this link to an article he wrote recently on text type columns. You can see more of his work at http://www.sqlservercentral.com/columnists/jgama/.

Numeric Datatype Decisions

Last week we discussed character datatypes and their performance effects on your database. This week,we will dive into numeric datatypes. We will discuss how SQL Server numeric datatypes are stored and the pros and cons of each.

New SQL Server 2000 Data Types

In the latest release of SQL Server, Microsoft has added a number of new data types to expand the functionality of SQL Server.