O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Filegroups

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.

NOTE

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required