I have not had to store large amount of text in a database before. I know how to import it with SSIS of SQL code.
However, I want to be able to do Full Tet searches on it; an I know how to do that too; including setting it up and indexing it.
What I do not know, is how this is normally done. That is it would seem to me, and what I need to happen, is that each record holds the text. This is big text as it is from audio transcripts.
Can you tell me how do this please.