?
Solved

Performance issue with ntext field data type

Posted on 2009-05-14
3
Medium Priority
?
253 Views
Last Modified: 2012-05-07
Hello,
I have an application with 40 fields. One of the field is "Notes" with nvarchar(255). Now my client is requesting it to make it nText. I have few questions:
1. Will I loose data when changing the data type from nvarchar to ntext?
2. Assuming that over a period of time, I will have 50,000 records in this table, will having ntext hamper the performance when running with .NEt application?

Regards,
MI
0
Comment
Question by:vj_mi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 46

Accepted Solution

by:
tbsgadi earned 1600 total points
ID: 24383528
Hi vj_mi,

Try using NVARCHAR(MAX) instead


Good Luck!

Gary
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 24383534
0
 
LVL 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 400 total points
ID: 24383540
>1. Will I loose data when changing the data type from nvarchar to ntext?
no.

>2. Assuming that over a period of time, I will have 50,000 records in this table, will having ntext hamper the performance when running with .NEt application?
not necessarily.

now, wzhat is the version of you sql server?
if it's sql 2005 or higher, don't use ntext, but nvarchar(max) instead.
if it's sql 2000, is nvarchar(4000) not big enough?
  you might consider to have a list of "notes" to be attached, instead of having just 1 big notes field...
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question