Every once in a while I run into a weird COM error when running SQL Server Management Studio. Here is a quick article that shows you how to fix it.
Reorganize and Rebuild Indexes in SQL Server
Fragmented data can cause SQL Server to perform unnecessary data reads, slowing down SQL Server’s performance. Time to clean house Reorganizing and rebuilding indexes is a quick way to optimize your databases’ performance. We periodically (daily, weekly, or monthly) perform database reorganization on all the indexes on all the tables in our databases and those of […]