I dream about the day of right clicking a table and choosing "defragment." This wonderful built in utility would then return my table to it's initial fill factor and clean up all the allocations of extents to ensure that they were contiguous.
I'm not sure I'd want it that accessible, although it's already an option in the right-click menu of the index so it's already fairly accessible.
I heard of a case at my former company where one of the DBAs took down the production system for 3 hours after he was playing around in object explorer, right-clicked the index and selected rebuild.
Offline rebuild of the clustered index of a 52 million row table in peak business hours.
Call me a cynic, but I think if that option was there we'd still get lots of questions about fragmentation, plus a few more reading
"I selected the defragment option and now all the queries are timing out. Please help."
Personally I'd like to see a bit more said about what operations will do (in the graphical wizards anyway) so that people can't say that they didn't know what it was going to do.
One other thing that would be great (and maybe I should just write it) would be a built-in tool to check for good maintenance and admin practices and would show a report that said something like:
Database X has not been backed up in 167 days.
Database Y is in full recovery model but has no log backups. Log drive will fill up in approximately 24.2 minutes at current rate of growth.
Database Z has been shrunk 42 times in the last week and has grown 178 times in the same period. A defragment of indexes and drive is recommended
CheckDB has not been run on Database K in 127 days
... etc, etc...
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass