SQL Server 2000 SP4 New Features

SQL Server 2000 SP4 new features overview Author: changelive Source: saide.com

[Abstract] Microsoft is about to make many changes to SQL server: all new SQL Server 2005, attractive SQL Server express and SQL Server 2000 Service Pack 4.
[Keyword] sqlserver SP4 new features Microsoft is about to make many changes to SQL server: all new SQL Server 2005, attractive SQL Server express and SQL Server 2000 Service Pack 4. The last SP4, which will immediately affect SQL Server users, is because of its new correction set, function extension, and features added to SQL Server.

SP4, just as all previous service packages are accumulated; it contains all previous service packages. It has not yet been released, but it is already in the final test and will soon become a candidate product for release.

The most important new features of SQL Server you found in SP4 are as follows:

64-bit enhancement. The 64-bit hardware is gradually becoming common. It is not a special case. Therefore, SP4 added support for AMD's amd64 platform and Intel's extended platform in the wow subsystem, and made major changes to the 64-bit SQL Server. Now, it allows people to run 32-bit SQL servers and seamlessly transfer them to 64-bit versions as needed. (This is the first patch to release the SQL Server service package for the 64-bit SQL Server version.

Including MSXML 3.0sp6. SQL Server's support for XML is becoming more and more important and widely used. Therefore, it is of practical significance to add it to the service package. SQL Server2000 SP3 (and 3A) does not contain MSXML. You must install it separately. By default, SP4 includes MSXML and version 3.0, which has enhanced performance compared with earlier versions 2.6. However, SQLXML 3.0 SP3 is still not included in SP4; you need to download and install it separately (after SP4 is added) to ensure that you can use it.

Bug fixes. There are more than 230 bugs that need to be fixed or handled, but only 80 bugs in SP3. Some bugs fix incompatibility issues or functional issues in SP3. For example:

-The merge and copy operations in SQL Server2000 SP3 cannot be synchronized. This error is reported as a "permission error", but it is actually because of a problem in the database during binary sorting, merging, and copying.

-The DTS designer may be able to access data in violation of regulations after you Install SQL Server 2000 sp3. Administrators who rely on DTS for common block copy operations will be very happy to see that this problem has been corrected.

Some bugs that have been fixed will also have important significance for everyone, not just administrators:

-The error message "Performance Monitor shared memory creation failed:-1" appears when you start SQL Server. A common complaint about SP3 is that after SQL Server is stopped and restartedProgram(Such as performance monitor), no monitoring data can be collected.

-Apply SQL Server 2000 Protocol encryption to the JDBC client. In the past, Java database connections in windows were not allowed to be encrypted because JDBC could not call the correct API. SP4 solves this problem.

-"When tempdb is used more frequently, the concurrency problems will be reduced ." When a large number of temporary tables are generated at the same time, the database is affected.

You can obtain a complete list of bugs in the Microsoft Knowledge Base.

Remember, if you are planning to perform a thorough deployment of SQL Server 2000, you may obtain SP4 in SQL Server in advance, from selection, partners, and msdn resources. Microsoft also plans to allow users to manually deploy SQL Server 2005 and later versions through the installation media.

Note: If you are using the SQL Server2000 Analysis Service, there is an independent service package for this product. Not everyone uses the Analysis Service in sqlserver, so it is more meaningful to deploy it as an independent service package.

If you are interested in obtaining the SP4 version released in advance for detection, you can find it on Microsoft's beta website, use guest ID s2ksp4 (you need to enter a short survey when downloading to the pre-release version ). Do not install the beta version of SP4 in the product system; it is best to only put it on an isolated test computer.