SQLServerCentral.com Articles tagged Data Types

Converting Large Object Data Types

Tue, 14 May 2013 06:00:00 UT

Eliminate pesky legacy TEXT, NTEXT and IMAGE data types with this handy script.

Exploring the Varbinary Type

Thu, 07 Feb 2013 07:00:00 UT

A brief look at the Varbinary data type and its uses in SQL Server for beginners.

VARCHAR (MAX), NVARCHAR (MAX) and NTEXT Data Types

Mon, 21 Jan 2013 07:00:00 UT

Despite NTEXT and TEXT being deprecated in SQL Server for some time they are still both used in production systems. In this article, I will briefly demonstrate the difference between a VARCHAR (MAX), NVARCHAR (MAX) and the NTEXT data types, and the impact on performance from using NTEXT/TEXT.

SQL Server Data Type Precedence

Tue, 04 Sep 2012 06:00:00 UT

I am executing a simple query/stored procedure from my application against a large table and it's taking a long time to execute. The column I'm using in my WHERE clause is indexed and it's very selective. The search column is not wrapped in a function so that's not the issue. What could be going wrong?

SQL Server 2008 R2 Data Types

Wed, 22 Feb 2012 07:00:00 UT

A list of SQL Server 2008 R2 Data Types and Storage Sizes.

SQL Server 2008 T-SQL Enhancements Part - IV

Fri, 26 Mar 2010 06:00:00 UT

In the fourth installment that looks at T-SQL changes for SQL Server 2008, Ashad Ali examines how the Filestream data type works.

SQL Server 2008 T-SQL Enhancements Part - IV

Fri, 26 Mar 2010 06:00:00 UT

In the fourth installment that looks at T-SQL changes for SQL Server 2008, Ashad Ali examines how the Filestream data type works.

Creating User-Defined Data Types - SQL School Video

Thu, 18 Jun 2009 06:00:00 UT

Learn how you can create your own data types in this SQL School video. MVP Andy Warren explains the process of setting up user-defined data types.

Using the Timestamp Data Type - SQL School Video

Thu, 29 Jan 2009 07:00:00 UT

The timestamp data type is a unique data type in SQL Server. Brian Knight shows how it can be used in your tables.

Temporal Datatypes in SQL Server

Wed, 31 Dec 2008 07:00:00 UT

In the first of a series of articles on the tricks of tackling temporal data in SQL, Joe Celko discusses SQL's temporal data types and agonizes over the fact that, although there are ANSI/ISO Standards for temporal operations in SQL, every vendor has something different.

How to automate your .NET and SQL Server deployments
Deploy .NET code and SQL Server databases in a single repeatable process with Red Gate Deployment Manager. Start deploying with a 28-day trial

Data Types in SQL Server 2008

Wed, 10 Dec 2008 07:00:00 UT

Don Schlichting compares and contrasts the various SQL Server 2008 Data Types. In addition, he explores which Data Types are the best solutions for specific situations.

Investigating the new Spatial Types in SQL Server 2008 - Part 2

Thu, 20 Nov 2008 07:00:00 UT

This is the second article in the series on the new spatial data types in SQL Server 2008

Super Sizing Columns in SQL Server

Wed, 05 Nov 2008 07:00:00 UT

This article describes how to work with large objects in SQL Server using the MAX Specifier

SQL Server 2008: The New Data Types

Fri, 31 Oct 2008 06:00:00 UT

Brad continues his helicopter-level view of the most important new features of SQL Server 2008 with a look at the new data types, their use and their significance.

Auto generated SQL Server keys - uniqueidentifier or IDENTITY

Thu, 23 Oct 2008 06:00:00 UT

I'm designing a table and I've decided to create an auto-generated primary key value as opposed to creating my own scheme or using natural keys. I see that SQL Server offers globally unique identifiers (GUIDs) as well as identities to create these values. What are the pros and cons of these approaches?

The Many Benefits of Money…Data Type!

Thu, 02 Oct 2008 06:00:00 UT

Our initial reason for looking at the money data type can be found within the Precision Considerations for Analysis Services Users white paper. In this white paper, we provide extensive examples of the types of precision issues when your SQL relational data source and your Microsoft® SQL Server® Analysis Services cube have different non-matching data types (e.g., if you query one way you get the value 304253.3251, but run the query in another way and you get the value 304253.325100001).

SQL Server 2008: new data types and .Net 2 with and without SP1

Thu, 10 Jul 2008 06:00:00 UT

If you use the new data types in SQL Server 2008, and your front-end application uses .NET 2, you may hit difficulties. András explains why and how...

Top 5 hard-earned Lessons of a DBA
New! Part 4, ‘Disturbing Development’ by Grant Fritchey, features the return of Joe Deebeeay and a server-threatening encounter with ORMs - read it here

Reverse Engineering Alias Data Types in SQL Server 2000

Fri, 30 May 2008 06:00:00 UT

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.

Data Compression in SQL Server 2005 (Believe it !!)

Tue, 18 Mar 2008 06:00:00 UT

That’s correct. SQL Server 2005 SP2 supports data compression using Vardecimal data type.

12 essential tools for database professionals
The SQL Developer Bundle contains 12 tools designed with the SQL Server developer and DBA in mind. Try it now.

New Data Types in SQL Server 2008 Part 3

Fri, 22 Feb 2008 07:00:00 UT

This is the third articlefrom Dinesh Asanka in the series on the new Data Types in SQL Server 2008. In this article the spatial data types are explored.

New Data Types in SQL Server 2008 Part 2

Wed, 20 Feb 2008 07:00:00 UT

In this article, we are going to explore the new HierarchyID data type. We are going to show how to implement hierarchies in SQL Server 2005 and than how same thing in can be achived in SQL Server 2008 using the HierarchyID data type.

Top 5 hard-earned Lessons of a DBA
New! Part 4, ‘Disturbing Development’ by Grant Fritchey, features the return of Joe Deebeeay and a server-threatening encounter with ORMs - read it here

Optimize T-SQL data types in SQL Server

Wed, 26 Dec 2007 07:00:00 UT

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.

SQL Server 2008 New DATETIME DataTypes

Tue, 11 Dec 2007 07:00:00 UT

SQL Server 2008 introduces four new DATETIME datatypes as well as new DATETIME functions.

TinyInt, SmallInt, Int and BigInt

Mon, 10 Dec 2007 07:00:00 UT

SQL Server guru David Poole takes a look at the different integer data types and the impact of each of those on your database.

Reverse Engineering ADTs in SQL Server 2000 - Part 3

Thu, 27 Sep 2007 06:00:00 UT

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

Fri, 30 May 2008 06:00:00 UT

TinyInt, SmallInt, Int and BigInt

Mon, 10 Dec 2007 07:00:00 UT

SQL Server guru David Poole takes a look at the different integer data types and the impact of each of those on your database.

Numeric Datatype Decisions

Fri, 29 Oct 2004 06:00:00 UT

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.

Unique Identifier: Usage and Limitations

Thu, 24 Jun 2004 06:00:00 UT

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

Thu, 20 Nov 2003 07:00:00 UT

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/.