Defrag me please........ 08 February 2011 Don-Rickman SQL Server - Admin (0) Simplest way to reorganize all of the indexes for the the tables in your database. Defragment / Reorganize all tables EXEC sp_MSforeachtable 'alter index all on ? reorganize'