221 reputation
19
bio website dangowans.com
location Canada
age
visits member for 2 years, 4 months
seen Aug 20 at 17:11

Aug
20
awarded  Tumbleweed
Aug
14
awarded  Supporter
Aug
14
comment SQL Server 2005: Full-text search on a multi-lingual table
That could work. I fear that future updates and upgrades to the CMS would be potentially harder, especially if changes are made to the articles table. Great suggestion for an in-house system though.
Aug
14
comment SQL Server 2005: Full-text search on a multi-lingual table
Excellent suggestion, however I'm dealing with the limitations of a third-party CMS. Reworking the schema is unfortunately not a possibility.
Aug
14
asked SQL Server 2005: Full-text search on a multi-lingual table
Aug
14
comment SQL Server 2005: Full-text search space requirements
Or the "average number of noise words in an English article". The final number can only get better.
Aug
14
comment SQL Server 2005: Full-text search space requirements
I wonder if there are some statistics out there, like the "average number of unique words in an English article" that would make this calculation more accurate.
Aug
14
awarded  Teacher
Aug
13
revised SQL Server 2005: Full-text search space requirements
Missed multiplying by article count.
Aug
13
answered SQL Server 2005: Full-text search space requirements
Aug
13
comment SQL Server 2005: Full-text search space requirements
I do have an R&D server available for testing, so that may be the only way. Just wondering if a magic formula existed for calculating such a thing.
Aug
13
comment SQL Server 2005: Full-text search space requirements
That query works well to check the status of an existing catalog. I'm looking to determine how large an uncreated catalog will be, based on the data that will be thrown into it. Sorry for the confusion. I updated my question accordingly.
Aug
13
awarded  Editor
Aug
13
revised SQL Server 2005: Full-text search space requirements
Further clarification, index has no yet been made.
Aug
13
asked SQL Server 2005: Full-text search space requirements
Aug
13
awarded  Analytical
Aug
13
awarded  Scholar
Aug
13
accepted SQL Server 2005: Full-text search, order by matches
Aug
13
comment SQL Server 2005: Full-text search, order by matches
That is exactly what I'm looking for. Thank you!
Aug
13
asked SQL Server 2005: Full-text search catalog design