New answers tagged maintenance
Digging a bit on this, using a common query to retrieve index fragmentation took just about an hour even to return 160 rows on a 1.5TB database: SELECT s.name AS schemaname , t.name AS tablename , t.object_id , i.name AS indexname , i.index_id , x.page_count , x.avg_fragmentation_in_percent , ...
I have achieved this(How to delete the remote files older than N days on schedule from SQL Server 2012 (with SqlServerAgent job). I have been running backups of SSAS databases, and needed to delete the old backup files, on a different server. Please see run-a-powershell-script-on-a-different-server-from-inside-a-sql-server-job
Top 50 recent answers are included