Blog

If you work with SQL Server databases, you work with filegroups. Learn what filegroups are, cover best practices for using them, and see them in action! Bring your hard hat – we’re diving into the database structure!

Did you enjoy this session? There’s more where that came from! I’ll be presenting “The What, Why, and How of Filegroups” at PASS Summit on Wednesday, November 7. This session is 75% demos – come see filegroups in action!

Every DBA needs to know how to create and maintain filegroups because they are part of every SQL Server database. Filegroups affect the performance, maintenance, and security of your data. What are filegroups, and how do you use them?
In this session, we’ll see how to create filegroups, create objects in them, move objects between them, and perform maintenance on them. We’ll also walk through piecemeal restores. The information in this session will help you create databases that perform better and are easier to maintain.

If you liked this video, check out our free SQL Server videos and our free upcoming webcasts.

↑ Back to top
  1. Hi, I have a database with 500 GB, where a single table occupies 92% of the space, I want to move this table to another filegroup, however this table have LOB data, and if I recreate the clustered index the LOB data will not be moved along with the regular data. Can you recommend the best way to do this?

    Thanks.

  2. Pingback: Storage – Part I | sqlpadawan

  3. One of our customers wants us to separate tables in different file groups for security reasons. It still doesn’t make sense to me why using different filegroups would increase the security of the information. What’s your opinion on this? Also are there any performance implications if we separate tables in different filegroups for no apparent reason?

    Thank you!

    • I’ve never used filegroups to increase security in a SQL Server database – I’m not sure, either, how that would help.

      The performance implication of spreading a table across multiple files in a filegroup is related to the disk subsystem(s) they are created on. Creating the filegroup, then spreading the files across two or more disks could provide a performance improvement – but it’s something that needs to be tested.

  4. In a scenario that you have a table in a filegroup1 that references a table in filegroup2 is it possible to do a piecemeal restore?

    If yes how will data integrity be broken?

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

css.php