I have a table with just over a million records with a full-text index.
This table has been split in two in the past, and the data older than a certain date is moved to another table with the exact same structure in a separate database at the end of every year. This second table has approximately 3+ million records.
I can only guess why this has been done, but now I've been asked to merge this two tables back into a single one, and partition it. I'm running SQL Server 2005.
Will the full-text search work in partitioned tables?
Are there any recommendations regarding this situation, or anything I should pay attention to?