Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Articles with tag Maintenance Rss

Search for any content tagged maintenance

   Items 1 to 11 of 11   

Backup File Inventory

Are you using Ola Hallengren's Maintenance Solution? Here's a Python script that helps you keep track of your backup file inventory.  Read more...
By Joel Askey 2016/01/25 | Source: | Category: backups
Rating: |  Discuss |   Briefcase | 2,092 reads

Stairway to SQL PowerShell Level 11: SQL Server Maintenance Using SQL PowerShell

This level will demonstrate simple techniques to perform a few important SQL Server maintenance tasks using PowerShell. We'll barely scratch the surface of what's possible but I hope it will whet your appetite.  Read more...
By Ben Miller 2015/12/16 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,808 reads

A general way to maintain History tables

You will see here a way to handle history tables. This way only takes into account Date-based data cleanup but is easily generalizable.  Read more...
By Jefferson Elias 2015/09/28 | Source: | Category: maintenance
Rating: |  Discuss |   Briefcase | 7,890 reads

The Real World: Rebuilding Index - 1 Instance, 106 Databases

The article show a simple way we managed to schedule index rebuild and reorg for an SQL instance with 106 databases used by one application using a Scheduled job.  Read more...
By Kenneth Igiri 2015/02/17 | Source: | Category: indexing
Rating: |  Discuss |   Briefcase | 6,061 reads

The MidnightDBAs release Minion Reindex

The MidnightDBAs have developed a free reindexing solution to help DBAs perform maintenance on their instances. Read about the solution and attend their webinar.  Read more...
By Press Release 2014/10/24 | Source: | Category: press release
Rating: |  Discuss |   Briefcase | 1,982 reads

Developing Low-Maintenance Databases

Alex Kuznetsov's team of developers are geared to doing rapid development of database applications in a busy corporate setting, yet take considerable time over meticulous database design, extensive constraints, automated tests, error logs, and defensive coding. Why? Because it cuts down on the subsequent need for maintenance.  Read more...
By Additional Articles 2012/07/23 | Source: SimpleTalk | Category: maintenance
Rating:  Rate this |   Briefcase | 3,742 reads

Automatic Statistics Update Slows Down SQL Server 2005

I have a database which has several tables that have very heavy write operations. These table are very large and some are over a hundred gigabytes. I noticed performance of this database is getting slower and after some investigation we suspect that the Auto Update Statistics function is causing a performance degradation.  Read more...
By Additional Articles 2011/02/25 | Source: | Category: maintenance
Rating: (not yet rated)  Rate this |   Briefcase | 4,976 reads

Retrieve Default SQL Server Backup Folder using PowerShell

In a previous tip on creating a Function to Return Default SQL Server Backup Folder , you've seen how you can create a T-SQL function to query the registry and retrieve the default SQL Server Backup folder. Is there an easier way to do it in Windows PowerShell?   Read more...
By Additional Articles 2010/04/23 | Source: | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,340 reads

Organizations With No DBAs

You have just been hired to help, "do database stuff", at a new company.  Read more...
By Sean Grinslade 2008/09/19 | Source: | Category: career
Rating: |  Discuss |   Briefcase | 12,949 reads

What do you do with a new SQL Server?

This article highlights some basic steps to take when you have a new install of SQL Server or take over support of existing databases.  Read more...
By Carolyn Richardson 2008/06/12 | Source: | Category: alerts
Rating: |  Discuss |   Briefcase | 7,767 reads

Reporting on Activity across Multiple Servers using SQL Backup and SQL Multi Script

Rodney Landrum presents a creative solution for dynamic reporting across all of his SQL Servers, based on use of Red Gate's SQL Backup and SQL Multi Script.  Read more...
By rodneylandrum 2008/01/22 | Source: | Category: backup and restore
Rating: |  Discuss |   Briefcase | 2,602 reads
   Items 1 to 11 of 11