Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
geossl
Yak Posting Veteran
85 Posts |
 Posted - 2005-05-12 : 08:47:06
|
| Dear All, The is a field using ntext (memo). As the data size grows, the performance degrades. As it is a ntext, no index can be created. Moreover, there is problem and inconveniences in utilizing full text index. Any solution to improve the speed? Thanks. |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-05-12 : 09:24:18
|
| Yeah, don't use that datatype....what's the max size of the column now?Brett8-) |
 |
|
|
geossl
Yak Posting Veteran
85 Posts |
Posted - 2005-05-13 : 02:23:05
|
The situation is it is not possible to change back to nvarchar as it is promised to the user before. Any other choice?quote:
Originally posted by geossl
Dear All, The is a field using ntext (memo). As the data size grows, the performance degrades. As it is a ntext, no index can be created. Moreover, there is problem and inconveniences in utilizing full text index. Any solution to improve the speed? Thanks.
|
|
|
|
|
|
|
Perform on ntext (memo datatype)