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

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: SQLServerCentral.com | Category: press release
Rating: (not yet rated) |  Discuss |   Briefcase | 209 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,533 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,663 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 | 2,029 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,946 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,748 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,598 reads
   Items 1 to 7 of 7