On the left side, under plan tasks, choose REBUILD INDEX TASK and drag it into the main window. This opens up the Maintenance Plan editor. In SQL Server Management Studio, connect to your server, then go to MANAGEMENT -> MAINTENANCE PLANS. If you're not a DBA, the easiest thing for you to do will be to use SQL Server's built-in Maintenance Plan. You should only do that if you expressly know that the application using the database calls for it. Setting every index in your database to have a default fill factor of 80 is not a good idea, in my opinion. Megasmithers, while the script that Eric posted should work, I would recommend setting your FILLFACTOR to 100 unless you have a specific reason to do otherwise. The tables all seem to start with "dbo." like "dbo.StatisticalPing" so it LOOKS like it should just be. There's no problem with taking the DB offline.
The only thing running on this Windows box is SQL Server and the WUG server that it's there for (and of course the web server for WUG's interface). Having my monitoring fail because database reads/writes time out is also expensive. I don't care how "expensive" an operation is, because you know what's an expensive operation? Opening a folder, right-clicking on the Index, hitting Reorganize, waiting forever, hitting enter, waiting forever, and then doing it all over again for 240+ of these folders.
and that Rebuild takes that database (or just table?) offline until it's done, but Reorg doesn't. that's what their folder says they are), right-click on the Indexes folder and Reorganize/Rebuild.
The only useful thing I found was how to get into the tables (I think. I found what looked right, but I guess it's for T-SQL which is. I don't even know what most of the stuff I've found means. I've Googled, but here's the thing: I'm a SysAdmin, I'm a NetAdmin, I've dabbled in programming, but I am so not a DBA and that's not a goal of mine. dm_db_index_physical_stats ( DB_ID ( N 'Whatsup.dbo' ), NULL, NULL, NULL, 'SAMPLED' ) ORDER BY page_count DESC
SQL SELECT OBJECT_NAME ( OBJECT_ID ), index_id, index_type_desc, index_level, avg_fragmentation_in_percent, avg_page_space_used_in_percent, page_count FROM sys.