SQLServerCentral.com Content tagged T-SQL, Data Types

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.

Data Typing Quandry

Wed, 17 Nov 2010 07:00:00 UT

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.

Varchar or Char?

Fri, 16 Oct 2009 06:00:00 UT

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.

char to datetime!

Wed, 19 Aug 2009 06:00:00 UT

decimal

Wed, 17 Jun 2009 06:00:00 UT

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

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?

CASTing

Thu, 29 May 2008 06:00:00 UT

CASTing

Tue, 27 May 2008 06:00:00 UT

Bit data

Wed, 07 May 2008 06:00:00 UT

Implicit Conversions

Mon, 05 May 2008 06:00:00 UT

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

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.

Make working with SQL a breeze
SQL Prompt 5 is the effortless way to write, edit, and explore SQL. It's packed with features such as code completion, script summaries, and SQL reformatting, that make working with SQL a breeze. Try it now.

Default Character Cast

Fri, 07 Dec 2007 07: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.