Maintaining database is the responsibility of DBA and it is done periodly. But it seems that many DBA do not like to use Maintenance Plan integrated to SQL Server.
I have found a maintenance script in which the author wants to have more controls on the task.
Refer here: http://blogs.msdn.com/b/blogdoezequiel/archive/2011/07/03/adaptive-index-defrag.aspx?goback=%2Egde_4362291_member_5798930868206583811#%21
Adaptive Index Defrag
0 comments:
Post a Comment