Re: Full text index not tracking changes on an indexed view

Tech-Archive recommends: Speed Up your PC by fixing your registry

I apologize for my mistake. Incremental update requires a timestamp column whereas change tracking doesn't.

--
Jean-Pierre Riehl
http://blog.djeepy1.net
http://www.bewise.fr

"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message news:%23CQlfIT0HHA.1188@xxxxxxxxxxxxxxxxxxxxxxx
Change tracking does not require a timestamp column.

I think your problem will be solved if you do use change tracking (as the previous poster points out).

--
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
"Jean-Pierre Riehl" <jean-pierre.riehl@xxxxxxxxxxxxxx> wrote in message news:1C0C02A3-0A2F-4294-97CA-59E453DE6780@xxxxxxxxxxxxxxxx
Hi Mark,

Do you have a timestamp column in underlaying table(s) ?
Have you activated automatic change tracking for your index ?

--
Jean-Pierre Riehl
http://blog.djeepy1.net
http://www.bewise.fr

<mbedser@xxxxxxxxx> wrote in message news:1185555299.154393.224920@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
We had a peculiar situation today where our lovely indexed view
obviously had textual data in it but some recently added rows were not
being returned in a CONTAINS query when they should have been.
Deleting and recreating the FT index fixed things immediately and I
can't seem to reproduce it but it worries me for our live deployment
(due imminently!).

Has anyone else seen this? Is it reproducible (and fixable?!)

Mark





.

Relevant Pages

  • Re: Full text index not tracking changes on an indexed view
    ... Change tracking does not require a timestamp column. ... previous poster points out). ... can't seem to reproduce it but it worries me for our live deployment ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Confusion: "Manual", "Incremental", "Update"
    ... ALTER FULLTEXT INDEX by considering whether we have timestamp column or not. ... Change Tracking can be continuous or on demand. ... An incremental population will extract each row from your table and detect ...
    (microsoft.public.sqlserver.fulltext)
  • Re: FTS and deadlocks
    ... Use change tracking over the other population methods if the tables are big. ... The timestamp column won't really help you with change tracking once the ... Director of Text Mining and Database Strategy ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.fulltext)
  • Re: How to call FullTextPopulation method?
    ... In addition this table has timestamp column. ... Incremental updates will reprocess the entire table looking for changes. ... You're better off using Change Tracking - then only the rows that have had ... Dan ...
    (microsoft.public.sqlserver.fulltext)