Reasons for sticking with TEXT, NTEXT and IMAGE instead of (N)VARCHAR(max) and VARBINARY(max)

Posted by John Assymptoth on Stack Overflow See other posts from Stack Overflow or by John Assymptoth
Published on 2012-10-24T22:58:23Z Indexed on 2012/10/24 23:00 UTC
Read the original article Hit count: 153

Filed under:

sql-server

|

deprecated

|

sql-server-2012

|

benefits

TEXT, NTEXT and IMAGE have been deprecated a long time ago and will, eventually, be removed from SQL Server.

However, they are not going to be discontinued right away, not even in the next version of SQL Server, so it's not convenient for my enterprise to transform thousands of columns right away, even if it is using SQL Server 2012.

What arguments can I use to postpone this migration?

I know there are some advantages in using the new types. But I'm strictly looking for reasons not to migrate my data that is already functioning pretty well in the old types.

© Stack Overflow or respective owner

Related posts about sql-server

SQL SERVER – Beginning SQL Server: One Step at a Time – SQL Server Magazine

as seen on SQL Authority - Search for 'SQL Authority'
I am glad to announce that along with SQLAuthority.com, I will be blogging on the prominent site of SQL Server Magazine. My very first blog post there is already live; read here: Beginning SQL Server: One Step at a Time. My association with SQL Server Magazine has been quite long, I have written nearly… >>> More
How to install SQL Server 2005 Configuration Manager without installing SQL Server Management Studio

as seen on Server Fault - Search for 'Server Fault'
Hi, I need to configure SQL Server aliases on a public-facing production server. To do that, I need to install SQL Server Configuration Manager. I was not able to find a standalone installer for that, so I am having to install SQL Server 2005 Client Components. This approach is not ideal as we don't… >>> More
[MAJ] SQL Server 2005 Express Edition - La version gratuite de SQL Server 2005

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Modification technique pour le site de l'article. >>> More
How to create SQL Server Express DB from SQL Server DB

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a SQL Server 2008 DB. I want to extract SOME tables (and associated schema, constraints, indexes, etc) and create a SQL Server Express DB. It isn't a sync of the target, we stomp on it. We ONLY need to do this in the file system (not across the wire). We are not fond of the synchronization… >>> More
sql server 2000 error, error trying to connect to sql server 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
i am connecting to sql server 2000 on a remote computer with a dotnet application, but when i try to open the connection it gives the following error: When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections What… >>> More

Related posts about deprecated

Hot to fix nautilus desktop on linux mint

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
so I'm using Linux Mint 13 with Cinnamon and suddenly there are no icons on the desktop and the right click doesn't work, it's like the desktop doesn't start up at all, but the Cinnamon interface and everything else are working just fine. This happens only when I open the session with Cinnamon, if… >>> More
PHP 5.3 SOAP deprecated errors

as seen on Stack Overflow - Search for 'Stack Overflow'
All, I am using PHP 5.3.1 under Ubuntu and using the SOAP package. I am getting the following errors when I include SOAP/Client.php. Any one knows how to get this working? Thanks Deprecated: Assigning the return value of new by reference is deprecated in /opt/lampp/lib/php/SOAP/WSDL.php on… >>> More
PHP 5.3.8 startup warning

as seen on Stack Overflow - Search for 'Stack Overflow'
How do I solve my PHP startup warning: PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php/extensions /no-debug-non-zts-20090626/imap.so' - /usr/lib/php/extensions/no-debug-non-zts-20090626 /imap.so: cannot open shared object file: No such file or directory in Unknown on line… >>> More
Logging Errors with messages in Codeigniter

as seen on Stack Overflow - Search for 'Stack Overflow'
I’m using codeigniter on a production server, and I’m not able to properly log the errors generated to the file. I edited php.ini like this- error_reporting = E_ALL | E_NOTICE | E_STRICT|E_WARNING display_errors = Off log_errors = On error_log = "/var/log/php-scripts.log" // This is where I would… >>> More
why does perl complain "Use of implicit split to @_ is deprecated"

as seen on Stack Overflow - Search for 'Stack Overflow'
the code triger the complain is as below : #!/usr/bin/perl use strict; use warnings; my $s = "aaa bbb"; my $num_of_item = split(/\s+/, $) ; print $num_of_item; when I run the code, perl complains that "Use of implicit split to @_ is deprecated" . I really have no "context" for the problem, so… >>> More