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
Source : blogs.msdn.com/sharepoint
