TEXT data type in a large database

  • Hi all, I have a database with more than 200 tables and about 150 tables have many fields with a TEXT as a data type, which is stored externaly from the table. my question is where is best to place these colomns, my options are:

    > DATA disk

    > INDEX disk

    > LOG Disk

    OR System files DISK ??

    Thanks for the help,

    gilhidas

  • What version of SQL?

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • SQL2000

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply