-
Reindexing Filegroups
Hi all,
We have a maintanance plan scheduled to optimize the production database. Recently we added non-primary filegroups to this db. and placed static tables that only get updated once a month on these filegroups.
Now obviously we don't need the full database optimization on the regular basis.
Does anyone know how to optimize on the filegroup level??
Also I tried to rewrite the reindexing part in T-Sql as:
select 'dbcc dbreindex '+ '('''+ name + '''' + 'GO'
from sysobjects
where type = 'u'
and name not in ('table_1', 'table_2', 'table_3'
Does anyone know how to then call this sql to execute??
Any help will greatly appreciated.
Thanks
Narine
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|