Automating Database Administration Tasks FAQ
The following section lists some commonly asked questions and answers about SQL Server 2000 tasks.
| Q1: | Does the UDPATE STATISTICS command need to be run on a frequent basis? |
| A1: | No, the UPDATE STATISTICS command does not need to be run on a frequent basis. SQL Server 2000 automatically manages index statistics. If statistics are out-of-date, SQL Server will detect the problem and automatically update the statistics. |
| Q2: | Does DBCC CHECKDB still need to run in version 2000? |
| A2: | According to Microsoft, DBCC CHECKDB does not need to be run on a frequent basis. If you want to be overly cautious, it does not hurt anything to continue to run CHECKDB. The drawback to running CHECKDB is that object creation and ... |
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
