Chapter 8: SQL Server 2005 Maintenance Practices

Friday Nov 2nd 2007 by DatabaseJournal.com Staff
Share:

For SQL Server databases to perform at optimal levels, a database administrator (DBA) should conduct routine maintenance on each database.

[From Network World]

For SQL Server databases to perform at optimal levels, a database administrator (DBA) should conduct routine maintenance on each database. Some of these routine database tasks involve rebuilding indexes, checking database integrity, updating index statistics, and performing internal consistency checks and backups. These routine database maintenance tasks are often overlooked because they are redundant, tedious, and often time consuming.

The article continues at http://www.networkworld.com/subnets/microsoft/110107-ch8-sql-server.html

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved