New SQL Server 2005 Video Tutorial: Part 2 - Filegroups, Data Files, and Placement: How to Place a Table or Index on a Filegroup

Part 2 - Filegroups, Data Files, and Placement: How to Place a Table or Index on a Filegroup - view details

This video continues from the last video and is really showing how to perform Step 3 in how to make a table read-only.

Highlights from this video:

• How to create a table so that it is on a filegroup other than PRIMARY
  
• What is a heap? Why do clustered and non-clustered indexes matter when talking about making a table read-only?
  
• How to move an existing SQL Server table to a new filegroup
  
• how to move a clustered index to a new filegroup

and much more

---

• Source: http://www.learnsqlserver2005.com
• Category: Miscellaneous - Topics That Don't Fit Anywhere Else!
• Skill Level: 500 (Advanced)
• Length: 10:45 (17.0MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: performance tuning, advanced, filegroups, data files, read only