Hey i installed what you told here the link goes http://www.microsoft.com/downloads/details.aspx?familyid=4C6BA9FD-319A-4887-BC75-3B02B5E48A40&displaylang=en
But still i am not able to create a Full Search Text Index .. is it the correct version???? and even i see it in SQL server surface Area configuration the Service is Started but when i Query to enable the Full search text index it says its not installed on your computer or it not enabled ...???? 2009/8/8 ☺Aνιηαѕн ∂єѕαι™☺ <[email protected]> > > @John > > you are right I will download it ... > > > On Sat, Aug 8, 2009 at 8:10 AM, Brandon Betances <[email protected]>wrote: > >> Cache all the data in the application/web server and query that instead. >> Poll the SQL server every few minutes or something for changes. >> >> 2009/8/7 ☺Aνιηαѕн ∂єѕαι™☺ <[email protected]> >> >>> Hi All >>> >>> I have a table where it has 45000 Rows of data and a Column Named >>> Description will be used to search >>> >>> Just if user enters the Text like this *"Bailed out With"* >>> Where i split the String and will build the Query String >>> >>> and Query will be like this Select * from CaseList where Description >>> Like'%bailed%' or description like '%Out%' or description Like '%With%' >>> >>> This above Query Takes 15.6 Minutes to search data >>> >>> I think this can be solved by FullText Index search But i am using SQL >>> Express...??? >>> >>> Can any one tell me what to do to search data very fast??? please let me >>> know as soon as possible.. >>> >>> >>> -- >>> Thanks & Regards >>> Avinash Desai >>> *SAVE Nature SAVE Tree SAVE* >>> >>> Think Before you print: Please consider our environment before printing >>> this e-mail >>> >>> Charles de >>> Gaulle<http://www.brainyquote.com/quotes/authors/c/charles_de_gaulle.html> >>> - "The better I get to know men, the more I find myself loving dogs." >>> >> >> > > > -- > Thanks & Regards > Avinash Desai > *SAVE Nature SAVE Tree SAVE* > > Think Before you print: Please consider our environment before printing > this e-mail > > Jonathan > Swift<http://www.brainyquote.com/quotes/authors/j/jonathan_swift.html> - "May > you live every day of your life." -- Thanks & Regards Avinash Desai *SAVE Nature SAVE Tree SAVE* Think Before you print: Please consider our environment before printing this e-mail Stephen Leacock<http://www.brainyquote.com/quotes/authors/s/stephen_leacock.html> - "I detest life-insurance agents: they always argue that I shall some day die, which is not so."
