August 13, 2007 at 10:06 pm
i have just taken sql server 2005 workgroup edition on a lease for a sole purpose of full text search feature
iam storing resumes in a table, should i create a sperate table for storing resumes with full text searh or insert them into a column of a candidatestable
any other help, tutorials will be very useful
<a href="http://www.websolsoftware.com"> For IT jobs click here</a>
*Sukhoi*[font="Arial Narrow"][/font]
August 13, 2007 at 10:47 pm
any help?
<a href="http://www.websolsoftware.com"> For IT jobs click here</a>
*Sukhoi*[font="Arial Narrow"][/font]
August 15, 2007 at 4:31 am
Either way would work. Effectively you are doing a vertical partition on your data, so use the normal design criteria for checking if this is worthwhile. FTS would not care how you did this, as presumably you would only define a FTS index for the resume column.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply