title: Fulltext index's function Contains(JsonColumn, anyValue) stops working after inserting bulk(25k rows at a time) couple of times in SQL server
body: <p><strong>Below is the code for creating table-</strong></p>
  
  <pre><code>create table PipeRunTest(
    ID nvarchar(50) not null primary key,
    JsonData nvarchar(max)
    constraint PipeRunTest_CK check(isjson(JsonData) =1)
  )
  </code></pre>
  
  <p><strong>Creating FullText search index-</strong></p>
  
  <pre><code>create fulltext catalog jsonFullTextCatalog
  
  create fulltext index on PipeRunTest(JsonData) key index PK__PipeRunT__3214EC27F8F0771F on jsonTextCatalog
  </code></pre>
  
  <p><strong>This is how I'm inserting data-</strong></p>
  
  <pre><code>insert into PipeRunTest(ID,JsonData) values(NEWID(), 'Jsontext')
  </code></pre>
  
  <p><strong>Using contains to retrieve data-</strong></p>
  
  <pre><code>select * from PipeRunTest where contains(JsonData, 'PipeRun')
  </code></pre>
  
  <p><strong>Problem:</strong></p>
  
  <p>The <code>contains()</code> function does not return the data correctly. Either it does not return any rows or the number of rows are less compared to the original number of rows (checked by using <code>Json_Value()</code> method). It does not return rows inserted immediately. It takes time to update in table I guess? And so does not return if searched immediately.</p>