Another Newbie questions

Hi,
Do i need to populate the Full-Text catalog and Full-Text Index both in
order to get the most updated data? I thougth all I need to do is to
populate the Full-Text Index, if so, what is the reason to populate the
catalog, too?
If I need to populate both, do i have to populate the catalog first, then
Index?
Thanks for any explaination
Ed
Ed,
I guess the answer is both, but not because there are *two* objects, but
because often these terms are used interchangeable. See SQL Server 2000 BOL
(Books online) title "Full-Text Indexes" for more details on the differences
between "Full-text indexes" and "Regular SQL indexes" as well as BOL title
"Full-Text Catalogs and Indexes".
Specifically, you *populate* a FT Catalog via sp_fulltext_catalog
(start_full) as you can have more than one table per FT Catalog. However,
you set "Change Tracking" and "Update Index in Background" at the
table-level via sp_fulltext_table (start_change_tracking).
Hope this helps!
John
"Ed" <Ed@.discussions.microsoft.com> wrote in message
news:BB2E4741-C0D9-42C0-9B45-0802987E3DA8@.microsoft.com...
> Hi,
> Do i need to populate the Full-Text catalog and Full-Text Index both in
> order to get the most updated data? I thougth all I need to do is to
> populate the Full-Text Index, if so, what is the reason to populate the
> catalog, too?
> If I need to populate both, do i have to populate the catalog first, then
> Index?
> Thanks for any explaination
> Ed
|||A catalog may index one or more tables. If you are only indexing one table,
it makes no difference when you run a full population on the catalog or on
the index.
If you are indexing multiple tables, you should run a full popluation on a
table basis for performance reasons. In other words, it will be faster and
you will get better performance when run populations on a per table basis.
In general you should place index each table its own catalog as MSSearch
(the engine which does the indexing) allocates threads on a per catalog
basis. So the more catalogs you have the more threads there will be
servicing your indexing and querying processes. However, there will be
greater overheard with the larger number of threads and catalogs.
Even so if you are indexing large tables you can get performance increases
by splitting the table up into pieces/child table (this process is called
partitioning) and having a seperate catalog for each child table.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"Ed" <Ed@.discussions.microsoft.com> wrote in message
news:BB2E4741-C0D9-42C0-9B45-0802987E3DA8@.microsoft.com...
> Hi,
> Do i need to populate the Full-Text catalog and Full-Text Index both in
> order to get the most updated data? I thougth all I need to do is to
> populate the Full-Text Index, if so, what is the reason to populate the
> catalog, too?
> If I need to populate both, do i have to populate the catalog first, then
> Index?
> Thanks for any explaination
> Ed

another freetexttable question

i'm trying to usr two (or more) columns in the catalog in the select.
I can get all: FREETEXTTABLE(usr, * , @.term)
or 1 column: FREETEXTTABLE(usr, usrCompany , @.term)
but 2 or more: FREETEXTTABLE(usr, "usrCompany, usrBusDesc" , @.term)
doesn't work. I've seen in the book's on line that it can be done, but have
not found an example.
Any help appreciated! ...and Happy New Year!
thanks (as always)
some day i''m gona pay this forum back for all the help i''m getting
kes
Try
select * From FREETEXTTABLE(usr, (usrCompany, usrBusDesc) , @.term)
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"WebBuilder451" <WebBuilder451@.discussions.microsoft.com> wrote in message
news:5CB29272-DA9E-484F-BECE-CD63610A6736@.microsoft.com...
> i'm trying to usr two (or more) columns in the catalog in the select.
> I can get all: FREETEXTTABLE(usr, * , @.term)
> or 1 column: FREETEXTTABLE(usr, usrCompany , @.term)
> but 2 or more: FREETEXTTABLE(usr, "usrCompany, usrBusDesc" , @.term)
> doesn't work. I've seen in the book's on line that it can be done, but
> have
> not found an example.
> Any help appreciated! ...and Happy New Year!
> --
> thanks (as always)
> some day i''m gona pay this forum back for all the help i''m getting
> kes
|||thank's for responding and happy new year,
I did try that, but i keep getting: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '('.
thanks (as always)
some day i''m gona pay this forum back for all the help i''m getting
kes
"Hilary Cotter" wrote:

> Try
> select * From FREETEXTTABLE(usr, (usrCompany, usrBusDesc) , @.term)
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "WebBuilder451" <WebBuilder451@.discussions.microsoft.com> wrote in message
> news:5CB29272-DA9E-484F-BECE-CD63610A6736@.microsoft.com...
>
>
|||Is this SQL 2000? You can only do this in SQL 2005. In SQL 2000 its one
column or all columns (when you use a *)
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"WebBuilder451" <WebBuilder451@.discussions.microsoft.com> wrote in message
news:2AF649A4-3375-4772-9DC9-E96FDC365309@.microsoft.com...[vbcol=seagreen]
> thank's for responding and happy new year,
> I did try that, but i keep getting: Msg 170, Level 15, State 1, Line 1
> Line 1: Incorrect syntax near '('.
> --
> thanks (as always)
> some day i''m gona pay this forum back for all the help i''m getting
> kes
>
> "Hilary Cotter" wrote:
|||it's 2000, that's the answer!
Thank You!
thanks (as always)
some day i''m gona pay this forum back for all the help i''m getting
kes
"Hilary Cotter" wrote:

> Is this SQL 2000? You can only do this in SQL 2005. In SQL 2000 its one
> column or all columns (when you use a *)
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "WebBuilder451" <WebBuilder451@.discussions.microsoft.com> wrote in message
> news:2AF649A4-3375-4772-9DC9-E96FDC365309@.microsoft.com...
>
>