Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Full Text search option Expand / Collapse
Author
Message
Posted Wednesday, June 18, 2008 8:35 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, February 1, 2011 3:13 AM
Points: 139, Visits: 282
Hi,

Enabling Full Text search option in 2005 can increase performance of the query if how pls tell as i am doing R & D.

Waiting for the reply regarding Full Text search option.

Thanks in advance
Anjan:)
Post #519113
Posted Wednesday, June 18, 2008 8:51 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 10, 2010 5:07 AM
Points: 2,661, Visits: 23,078
FullText searching is a different type of querying. I would suggest you start by reading about it in Books Online and on the MS website and come back and post here if you have any specific questions.
Post #519134
Posted Wednesday, June 18, 2008 8:57 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, February 1, 2011 3:13 AM
Points: 139, Visits: 282
Actually we did the query tunning but still that query performance is not gud still getting timeout error.

I actually wanted to know in which or situation we are using full text search mode can u give some practical examples it will be good for me.

Post #519142
Posted Wednesday, June 18, 2008 9:25 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 5:59 PM
Points: 31,082, Visits: 15,529
Full Text searching is for searching large values of text for some data, similar to what you get with Google, Live Search, etc.

If you have queries that you are using to search for exact values, or they are small values (varchar(100 and less) , then you would use normal queries, not full text.

Full Text is for text. Did you read Books Online?







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #519182
Posted Wednesday, June 18, 2008 9:51 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, February 1, 2011 3:13 AM
Points: 139, Visits: 282
steve,

good examples and i have read in Bol also.
Post #519214
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse