New SQL Server 2005 Video Tutorial: Part 3 - Indexes, Data Placement, and How to Kill Everyone (in the Database!)

Part 3 - Indexes, Data Placement, and How to Kill Everyone (in the Database!) - view details

Our final video in our series on how to move tables and indexes to a read-only filegroup covers what requirements there are for assigning a filegroup read-only and how to do it in a production system. There are certain rules you must follow and, unless you follow them, you will not be able to make the database read-only!

Highlights from this video:

• How to change database state to SINGLE_USER, MULTI_USER or RESTRICTED_USER using ALTER DATABASE and the SQL Server Management Studio
  
• SQL script to kill all users in a database

and much more

---

• Source: http://www.learnsqlserver2005.com
• Category: Miscellaneous - Topics That Don't Fit Anywhere Else!
• Skill Level: 500 (Advanced)
• Length: 8:15 (14.6MB)
• 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