SELECT --'alter index all on ' + QUOTENAME(s.name) + '.' + QUOTENAME(t.Name) + ' rebuild with (sort_in_tempdb = on, data_compression = page)' as 'Tsql', --'alter ...
join sys.objects o with (nolock) on o.object_id = p.object_id join sys.schemas s with (nolock) on s.schema_id = o.schema_id left join sys.indexes i with (nolock) on i.object_id = p.object_id and ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback