Filegroups allow database files and objects to be logically grouped together. Tables, indexes, text datatypes, ntext datatypes, and image datatypes can be placed on specific filegroups (see Figure 8.15). By spreading database I/O across hard drives, filegroups provide the potential to improve database performance. Filegroups can also simplify administrative tasks such as backing up a filegroup or adding new files to new disks.

Figure 8.15. Filegroups.


If you are considering implementing filegroups, you should consider implementing hardware with RAID technology. A high quality RAID system can often deliver performance gains similar ...

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.