Explanation/Reference:
Explanation:
* Scenario: Database Issues
The current database does not perform well. Additionally, a recent disk problem caused the system to go down, resulting in lost sales revenue. In reviewing the current system, you found that there are no automated maintenance procedures. The database is severely fragmented, and everyone has read and write access.
* After the degree of fragmentation is known, use the following table to determine the best method to correct the fragmentation.
avg_fragmentation_in_percent value
/> 5% and < = 30%
then use
ALTER INDEX REORGANIZE
/> 30%
then use
ALTER INDEX REBUILD WITH (ONLINE = ON)
ALTER INDEX (Transact-SQL)