Database Maintenance for SharePoint Whitepaper
Bill Baer’s white paper: Database Maintenance for SharePoint is now live. Here's a sneak peak into the contents. Kudos Bill! This level of content is outstanding!
CHECK FOR AND REPAIR CONSISTENCY ERRORS BY USING DBCC CHECKDB
About DBCC CHECKDB
DBCC CHECKDB and performance
MEASURE AND REDUCE FRAGMENTATION
Measure fragmentation in a SQL Server 2005 database (sys.dm_db_index_physical_stats)
Measure fragmentation in a SQL Server 2000 database (DBCC SHOWCONTIG)
Reducing Fragmentation for a Database
Reducing fragmentation for a specific table and its indexes
Using ALTER INDEX
Fine tuning index performance by setting fill factor
Shrinking data files
Shrinking a database by using Transact-SQL commands
Shrinking a database by using SQL Server 2005 Management Studio
CREATING SQL SERVER 2005 MAINTENANCE PLANS
Configure a SQL Server 2005 Database Maintenance Plan
Thanks,
Joel Oleson
