Sql Sever 2005 - Full text Search

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Sql Sever 2005 - Full text Search

Author

Topic

UdayDenduluri
Starting Member

4 Posts

Posted - 2007-12-03 : 13:30:13

Full text search is the search functionality that enables a fast and easy way of searching text based data in SQL Server. Although the concept of full text search is not new in SQL Server 2005, there are considerable enhancements in performance and manageability of SQL Server 2005. http://aspalliance.com/1512_Understanding_Full_Text_Search_in_SQL_Server_2005.all

Uday Denduluri
Software Engineer
Refer my articles at http://aspalliance.com/author.aspx?uId=62740

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-12-03 : 13:37:43

great.

now answer me this:
I have a FTS on a table. i use containstable and it returns 20.000 rows. It takes 10 seconds.
what should i do to speed it up?
changing hardware isn't an option.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources