Home Forums SQL Server 7,2000 Strategies what is the best way to store text data RE: what is the best way to store text data
Antares686
SSC Guru
Points: 125444
More actions
March 26, 2004 at 8:28 am
#500668
Storing in a text column and using the Full Text Search engine does quite well. However depending on the amount of data building the Full Text index can take awhile so keep that in mind. See BOL for more info.