I have a table with 1626078 rows and a column of VARCHAR (MAX). I would like to take a guess and the amount of space I need to ask for when creating the full text index on the VARCHAR (MAX) column.
I did (8002 * 1626078) and it looks like my FTI will take approx 12.5GB. I got the 8002 value from 8000 characters + 2 bytes for the termination. Then multiplied that by the amount of rows in my table.
I am using SQL 2005 so if I am not mistaken the FTI goes in a separate file.
Did I miss anything? Am I heading into disaster?