数据库优化以及操作说明

【文件属性】：
文件名称：数据库优化以及操作说明
文件大小：229KB
文件格式：RAR
更新时间：2016-05-10 06:39:32
数据库优化 mssql优化 sql优化 优化 sql 索引优化：重建或者重新组织必要的索引 The SQL Server Maintenance Solution lets you intelligently rebuild or reorganize only the indexes that are fragmented. In the IndexOptimize procedure, you can define a preferred index maintenance operation for each fragmentation group. Take a look at this code: EXECUTE dbo.IndexOptimize @Databases = 'USER_DATABASES', @FragmentationLow = NULL, @FragmentationMedium = 'INDEX_REORGANIZE,INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE', @FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE', @FragmentationLevel1 = 5, @FragmentationLevel2 = 30 更新统计： The IndexOptimize procedure can also be used to update statistics. You can choose to update all statistics, statistics on indexes only, or statistics on columns only. If an index is rebuilt, the statistics is not being updated. You can also choose to update the statistics only if any rows have been modified since the most recent statistics update. EXECUTE dbo.IndexOptimize @Databases = 'USER_DATABASES', @FragmentationLow = NULL, @FragmentationMedium = 'INDEX_REORGANIZE,INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE', @FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE', @FragmentationLevel1 = 5, @FragmentationLevel2 = 30, @UpdateStatistics = 'ALL', @OnlyModifiedStatistics = 'Y'

【文件预览】：
数据库优化以及操作说明
----CommandExecute.sql(15KB)
----SQL Server Backup, Integrity Check, Index and Statistics Maintenance 说明.htm(14KB)
----MaintenanceSolution.sql(433KB)
----CommandLog.sql(1KB)
----SQL Server Backup, Integrity Check, Index and Statistics Maintenance_files()
--------sqlsentry-fragmentation-manager.jpg(41KB)
--------fusion-io.gif(29KB)
--------community-choice-2011-gold.jpg(36KB)
--------redgate-sql-backup.gif(10KB)
--------idera-sql-backup-status-reporter.jpg(55KB)
--------editors-best-2011-silver.jpg(31KB)
--------style.css(4KB)
----DatabaseSelect.sql(13KB)