May 18, 2006 at 8:01 am
I'm new to Full Text Indexing and am looking to start playing around with the feature. Does anyone know of anywhere that I can download a sample dataset to start using. This could be in the form of a backup file or instructions on how to create it. I've got a few good tutorials on how to use it but I'd rather start with a pre-created data set that demo's well rather than working to create my own.
If anyone has one or knows of the location of one for download I would appreciate it. I can provide an FTP site if needed.
May 18, 2006 at 12:00 pm
Jason,
CREATE FULLTEXT CATALOG (Transact-SQL)
CREATE FULLTEXT INDEX (Transact-SQL)
articles in SQL Server Books Online (BOL) have 3-line examples on how to create a full-text catalog and create an index. Then in the Enterprise Manager you may re-populate the index.
Searching for Specific word or Phrase (Simple Term)
article in BOL will give you an example of the query.
Regards,Yelena Varsha
May 18, 2006 at 12:02 pm
What I'm looking for is an example database or table that has meaningful data to work with. It'll take me all day to add 100,000 rows of test data into a database so I'm hoping that someone has one already created that they wouldn't mind sharing.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply