Subscribe:
RSS feed
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.
January 20, 2008
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 […]
January 20, 2008
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 […]
February 21, 2008
0