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 6 of 6   
 

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,499 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: MSSQLTips.com | Category: maintenance
Rating: (not yet rated)  Rate this |   Briefcase | 4,575 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: MSSQLTips.com | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 1,970 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: SQLServerCentral.com | Category: career
Rating: |  Discuss |   Briefcase | 12,945 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: SQLServerCentral.com | Category: alerts
Rating: |  Discuss |   Briefcase | 7,740 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: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 2,594 reads
   Items 1 to 6 of 6