New Microsoft SQL Server Video Tutorial: Pt 2 - Index-Related Tasks in SQL Server 2005 (the Rebuild Index, Reorganize Index, and Update Statistics options)

Pt 2 - Index-Related Tasks in SQL Server 2005 (the Rebuild Index, Reorganize Index, and Update Statistics options) - view details

Continuing our discussion on SQL Server 2005 Maintenance Plan tasks in the wizard, this video gives a nice overview of the index-related tasks, the "Rebuild Index", "Reorganize Index" and the "Update Statistics" tasks.

Scott Whigham, author of LearnSqlServer.com, walks you through a simple-to-understand discussion of how index fragmentation works, how data-distribution statistics are calculated and why tasks such as the Rebuild Index tasks are vitally important to the health of your SQL Server. Included in this video is a discussion of online defragmentation vs. offline defragmentation and a quick overview of the new ALTER INDEX ... WITH REBUILD or WITH REORGANIZE (instead of the DBCC DBREINDEX and DBCC INDEXDEFRAG).

Also included in this video is a discussion of how often you should run these tasks along with the impact that each task will have on your server and users. You’ll also understand why fragmentation occurs and how these tasks can help your database run faster.

• Category: Automating SQL Server: SQL Server Agent, Jobs, Email, Alerts and Scheduling
• Skill Level: 100 (Beginner)
• Length: 18:26 (13.7MB)
• Applies to Versions: SQL Server 2005
• 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