Browsing All Posts filed under »Datatypes«

Deprecated Datatypes

February 21, 2008

0

In case any sql dev’s wasn’t aware, TEXT and NTEXT will be deprecated. Seems like SQL 2008 could be the last version to have them, in any case I guess we should all think now about changing columns to VARCHAR/NVARCHAR(max) sooner rather than later. Advertisements

A Date with Dates

January 20, 2008

0

There are some interesting changes in the upcoming release of SQL Server 2008, some of which are powerful and sexy (“Spatial data” anyone?) and some have a less of a wow factor but never less are extremely useful. As a start, I wanted to write a special introductory post about the new date and time […]

Sparse Columns

January 20, 2008

0

SQL Server 2008 (“Katmai”) introduces something called Sparse Columns. What this allows you to do is to define a column that rarely contains data. When this is defined the column does not take up any space until it is used. An example of the code required to define the column is shown below. CREATE TABLE […]