Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 image/text fields

Author  Topic 

wardsan
Starting Member

48 Posts

Posted - 2004-10-26 : 03:58:43
Folks,
I am coming across an increasing number of applications that have tables with image and text fields. They are all nullable. I wondered what is best practice here. Should I be placing these fields in a separate filegroup and just keep them in the normal data filegroup? Is there any advantage to creating a filegroup just for image/text columns?
Thanks
   

- Advertisement -