Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Articles with tag Maintenance Rss

Search for any content tagged maintenance

   Items 1 to 9 of 9   

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,752 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,015 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,972 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,644 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,868 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,220 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,761 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 / restore
Rating: |  Discuss |   Briefcase | 2,598 reads
   Items 1 to 9 of 9