why disable full-text for sql server

[mflancour]

I was just reading about the full-text search option for server using contains(). and I have to wonder, why is it an option and not just always on?

 

[aalmeida]

there is no need to waist cpu and memory having a service on that is not going to do anything. don't you think?

AL Almeida
Senior DBA

http://www.saxotech.com/

"May all those that come behind us, find us faithfull"

 

[mrdenny]

The full text search option uses the MS Search service to index the database. This adds additional memory, CPU, and disk requirments for keeping the indexes up to date and for searching. As use of CONTAINS, CONTAINSTABLE, etc is not often it's better to not have to maintain all this extra data for no reason.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com