Full Text Indexing

Hello,
I wanna learn Full Text Indexing feature in MS SQL, Please let me know where could i have a good resource about it. I tried google but i didnt find what i need.

regardsStart with SQL Server's Books Online. Then move on to the resultsthat you get from this Google search: "Sql Server" "Full text indexing"
|||Try the link below for a two part article on Full Text indexing in SQL Server. Full Text is an add on to SQL Server dependent on Microsoft search service and the Catalog must be populated to get expected results for search with Microsoft Proprietry implementation of ANSI SQL CONTAINS, CONTAINSTABLE, FREETEXT and FREETEXTTABLE. Hope this helps.
http://www.databasejournal.com/features/mssql/article.php/3454281|||

I have the same problem did u find some good resources?

I am looking foward to find away to scale(ditrubute), the full text engine in my machines.

Please let me know what u have got.

|||

erdsah88:

I have the same problem did u find some good resources?

I am looking foward to find away to scale(ditrubute), the full text engine in my machines.

Please let me know what u have got.

The first thing you have to do is run searches that will not return a whole table because SELECT * returns a whole table so sometimes your predicates are ignored. What I mean is you are telling SQL Server I want the whole table and you then add a predicate which SQL Server consider a trick it gets your query very slow. So spend time with Management Studio and the Profiler to reduce the cost of your query, make sure you run all queries through your application so you know how it affects your performance. Jeff Prosise published a check list for Asp.net application data was one of the most important, I have told you to get a data person you ignored it, you need someone who knows SET Algebra so your tables will be cleaned and all your SELECT * DML(data manipulation language) will be dropped. Microsoft built a new physical architecture for SQL Server 2005 see if you can use the new INDEX COLUMN include and pay attention to the IAM(index allocation mapping) pages. All of the above will take a long time but will clean most of your existing problems. One more thing test drive the new Database Developer VS use it to clean your DML. Hope this helps.

http://msdn.microsoft.com/msdnmag/issues/06/07/WebAppFollies/

http://blogs.msdn.com/sqlserverstorageengine/archive/tags/Index+Fragmentation+Series/default.aspx

http://msdn2.microsoft.com/en-us/library/ms190806.aspx