Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 261
  • Last Modified:

Performance issue with ntext field data type

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
vj_mi
Asked:
vj_mi
  • 2
2 Solutions
 
tbsgadiCommented:
Hi vj_mi,

Try using NVARCHAR(MAX) instead


Good Luck!

Gary
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now