Browse > Home / Christophe Fiessinger's Blog, Project Management News / Database Maintenance for SharePoint

Database Maintenance for SharePoint

February 29, 2008 @ Christophe Fiessinger's Blog from chrisfie

Vote This Post DownVote This Post Up (No Ratings Yet)
Loading ... Loading ...


Bill Baer’s white paper: Database Maintenance for SharePoint is now live. 

Table of Contents

  • Check for and repair consistency errors by using DBCC CHECKDB 1
  • About DBCC CHECKDB 1
  • DBCC CHECKDB and performance 2
  • Measure and reduce fragmentation 3
  • Measure fragmentation in a SQL Server 2005 database (sys.dm_db_index_physical_stats) 4
  • Measure fragmentation in a SQL Server 2000 database (DBCC SHOWCONTIG) 5
  • Reducing Fragmentation for a Database 6
  • Reducing fragmentation for a specific table and its indexes 9
    • Using ALTER INDEX 9
  • Fine tuning index performance by setting fill factor 10
  • Shrinking data files 10
    • Shrinking a database by using Transact-SQL commands 11
    • Shrinking a database by using SQL Server 2005 Management Studio 12
  • Creating SQL Server 2005 Maintenance Plans 13
  • Configure a SQL Server 2005 Database Maintenance Plan 13
  • Summary 22

This article is syndicated from Christophe Fiessinger's Blog . The original article is available here. Read more in Christophe Fiessinger's Blog, Project Management News .

Tags:
Reminder : PMToolbox has ZERO tolerance to copyright violation and agrees to follow strictly PMI's Professional Responsibility. That's why each post on this site includes a link to the original version at its source site.

Related Posts

Comments

Got something to say?