SQL: Converting between NText and NVarChar

I have dozens of articles in draft state, and that need just a little polish to publish. But while the time is tight, here goes a link to a simple article about this kind of conversion.

Simply put: you may have performance issues from using NText on newer versions of SQL (be sure to set the most appropriate storage to be used in your columns, sometimes LOB can be good). One more thing to look at when migrating or converting databases from SQL2000 and up.

http://geekswithblogs.net/johnsPerfBlog/archive/2008/04/16/ntext-vs-nvarcharmax-in-sql-2005.aspx

Explanation about both data types:

http://stackoverflow.com/questions/564755/sql-server-text-type-vs-varchar-data-type

And how to identify these columns?

http://blog.sqlauthority.com/2007/08/09/sql-server-2005-list-all-the-column-with-specific-data-types/

TLDR (too long, didn’t read): just use NVarChar(max) instead of NText. When you get a chance, convert any data for the newer data types.

cya!

Advertisements

About mauriciorpp

Hi, I am Piccolo - but not the one from Dragon Ball. I'm from a highly competitive and fast-paced world too, the IT industry, and this space will be used to share some challenges I face daily on my career. As you will see, I don't do brawls but I need to be a fighter! Stay tuned.
This entry was posted in SQLServer and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s