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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Searching from text filed

Author  Topic 

sagitariusmzi
Posting Yak Master

113 Posts

Posted - 2009-06-19 : 00:46:28
Hi,

How to Imporve the searching of a field with data type of text,
What measures should be taken.

Mangal Pardeshi
Posting Yak Master

110 Posts

Posted - 2009-06-19 : 07:24:22
Since you asked "How to improve".. my suggestion is change the data type to VARCHAR(MAX) and make use of really powerful FullText Search.

Mangal Pardeshi
http://mangalpardeshi.blogspot.com
Go to Top of Page
   

- Advertisement -