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.
Michael Villegas October 25, 2012 | 5:06 pm
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.
Jes Schultz Borland October 26, 2012 | 8:19 am
Good question – that was outside the scope of this webcast. Check out this Q&A from SQL Server Pro – http://www.sqlmag.com/blog/sql-server-questions-answered-28/sql-server-2008-r2/moving-lob-data-142636.
Pingback: Storage – Part I | sqlpadawan