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 + ''&#39' + 'GO'
from sysobjects
where type = 'u'
and name not in ('table_1', 'table_2', 'table_3&#39

Does anyone know how to then call this sql to execute??

Any help will greatly appreciated.
Thanks
Narine