I am currently running Vista Ultimate with SP1. When I was running XP PRO I could defragment my disks myself. Now I can not find the exe. Vista wants to do it its self, I used to run a defrag several time to get back for usable disk space now it can't even see how fragmented my disks are. Does anyone know where the exe for defraging is hidding?
View 2 RepliesHi guru,I've been new company for only a month and started analysing IndexFragmentation.After I ran DBCC DBREINDEX and capture data into permanent table, I 'veseen lots of tables with no indexes. These tables showed:Very low scan density,High extent fragmentationHigh Avg. Bytes Free per PageWhat are the best strategies to defragment tables with no indexes?I'm planning to make a rule that each table must have a clustered indexand this index must be created on the best column (highestselectivity).Please help.Thanks,Silaphet,
View 1 Replies View Related