my maintenance plan for defrag-ing indexes was failing due to a disabled index
ran this to re-enable index:
ALTER INDEX [indexname] ON dbname.tablename REBUILD
GO
sql for everyone
my maintenance plan for defrag-ing indexes was failing due to a disabled index
ran this to re-enable index:
ALTER INDEX [indexname] ON dbname.tablename REBUILD
GO