Se ha publicado un Excelente documento sobre el Mantenimiento e Bases de Datos de ShrePoint 2007, el nivel es muy bueno. Descargar el Archivo desde el Sitio de Microsoft.
El Contenido :
CHECK FOR AND REPAIR CONSISTENCY ERRORS BY USING DBCC CHECKDB
About DBCC CHECKDBDBCC
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 DatabaseReducing fragmentation for a specific table and its indexesUsing ALTER INDEX
Fine tuning index performance by setting fill factorShrinking data filesShrinking a database by using Transact-SQL commands
Shrinking a database by using SQL Server 2005 Management Studio
CREATING SQL SERVER 2005 MAINTENANCE PLANSConfigure a SQL Server 2005 Database Maintenance Plan
No hay comentarios.:
Publicar un comentario