tags:

views:

111

answers:

0
Q: 

SQL Server Full text index size growing

I got a big table with around 10 million records. The table is part of full text index and the data contained in it is recreated daily. Now after recreating the data I rebuild the full text index using SQL:

ALTER FULLTEXT INDEX ON [table1] START FULL POPULATION;

The issue is that the folder containing full text index files size is growing every day. It started with 1 GB and is now around 10 GB.

What should I do to stop this growing size of full text index files?

related questions

What is the best way to change text contained in an XML file using Python?
Parsing Performance (If, TryParse, Try-Catch)
How to remove accents and tilde in a C++ std::string
newline character(s)
Windows batch command(s) to read first line from text file
XML vs Text for Non-web development applications
How do I modify a text file in Python?
python regular expression to split paragraphs.
Custom Text Wrapping in WPF
SQL strip text and convert to integer
What's the canonical way to store arbitrary (possibly marked up) text in SQL?
Text message receiving API - UK and USA
How can I detect the encoding/codepage of a text file
Keyboard scancodes?
How do I duplicate a whole line in Emacs?
Font rendering libraries for C# / dot-NET?
How to programmatically normalize music tags?
Best way to convert text files between character sets?
Highlight parents in xml string
A good algorithm similar to Levenstein but weighted for Qwerty keyboards?
Most elegant way to force a TEXTAREA element to line-wrap, *regardless* of whitespace
Adapt Replace all strings in all tables to work with text
Formatting text in WinForm Label
Text Editor For Linux (Besides Vi)?
In HTML, how to word-break on a dash?