• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 230
  • Last Modified:

SQL SERVER 2005 full text search Question

Hi,

I have to implement full text search on sql server  tables. It is already implemeted on a column(EmpName) in one of the table Employee. I need to swich to a different column(Resume) and also needs to implement on two new tables.

Could any one help me out on this. Here is the existing stored proc.
ALTER PROCEDURE [dbo].[SearchFullTextContent] 
@paramQuery nvarchar(200)
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
 
    -- Insert statements for procedure here
	select empID from Employee
	where  freetext(Employee.EmpName, @paramQuery) 
END

Open in new window

0
r_pat72
Asked:
r_pat72
  • 2
  • 2
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
0
 
r_pat72Author Commented:
I went through the above link. Here is the my questions :

1) For enable full text search for different table do i have to create new catalogs for all new tables.
2) After creating the full text index on columns, Do I have to do anything for Full text search implementation.
3) How can I test that it is working as expected.
4) Is there any performance improvement that I can do on this?


Please help me with this.

Thanks.
0
 
Aneesh RetnakaranDatabase AdministratorCommented:

>1) For enable full text search for different table do i have to create new catalogs for all new tables.
Since you already have a catelog, you dont really need to create another one, anyway creating one wont be so bad
>2) After creating the full text index on columns, Do I have to do anything for Full text search implementation.
You need to populate the data, right clicking on the table, scrollig over full text index and selecting "start full population"
>3) How can I test that it is working as expected.
Check the execution plans using a 'LIKE' statement and a FREETEXT/CONTAINS statement
4) Is there any performance improvement that I can do on this?
Full text indexes guarentee faster dataretrieval on varchar / txt columns
0
 
r_pat72Author Commented:
Thanks for your quick help.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now