Other News

Community

SQL 2005 Maintenance Wizard Part 1

(Don Schlichting) There are a number of database housekeeping tasks that should be done on a regular basis to insure SQL performance and data integrity are optimized. Backing up the database, reorganizing data and index files, compressing the data file, updating the index statistics, and performing

Community

FIX: CPU utilization may approach 100 percent on a computer that is running SQL Server 2000 after you run the BACKUP DATABASE statement or the BACKUP LOG statement

Consider the following scenario. You start the SQL Server 2000 service. You execute the BACKUP DATABASE statement or the BACKUP LOG statement at least one time. In this scenario, CPU utilization may approach 100 percent. After approximately 15 minutes or less, CPU utilization decreases.

Community

Error message when you use XML functionalities against an instance of SQL Server 2000 after you upgrade an instance of SQL Server 2000 to SQL Server 2005: ‘Failed to load msxmlsql.dll’

Consider the following scenario. A computer is running multiple instances of Microsoft SQL Server 2000. You update one of the instances to Microsoft SQL Server 2005. You use XML functionalities against one of the instances of SQL Server 2000. In this scenario, you receive an error message that resem