troubleshootingsql.com
Reorganize data and index pages
There are a few ways that this can be achieved: 1. Shrinking the database files (data file or transaction log file) 2. DBCC DBREINDEX (Similar to dropping and re-creating the indexes) 3. DBBC INDEX…