SQLServerCentral.com Articles tagged Maintenance

Developing Low-Maintenance Databases

Mon, 23 Jul 2012 06:00:00 UT

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.

Automatic Statistics Update Slows Down SQL Server 2005

Fri, 25 Feb 2011 07:00:00 UT

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.

Retrieve Default SQL Server Backup Folder using PowerShell

Fri, 23 Apr 2010 06:00:00 UT

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?

Organizations With No DBAs

Fri, 19 Sep 2008 06:00:00 UT

You have just been hired to help, "do database stuff", at a new company.

What do you do with a new SQL Server?

Thu, 12 Jun 2008 06:00:00 UT

This article highlights some basic steps to take when you have a new install of SQL Server or take over support of existing databases.

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

Tue, 22 Jan 2008 07:00:00 UT

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.