News

SQL 2K SP1 Hits Web

• By Scott Bekker
• 06/14/2001

The service pack, which comes 10 months after SQL Server 2000 was released to manufacturing, is not considered a required upgrade. "I can't point to one thing where we say we recommend this is something to fix," says Jeff Ressler, lead product manager for SQL Server 2000. "It's not something that we insist that all customers install."

The service pack includes 240 fixes. About 60 of those address bugs in SQL Server 2000 Analysis Services, the portion of SQL Server 2000 for OLAP and data mining.

Microsoft broke the service pack into three components. A core database component is a 45 MB download, an Analysis Services component is 38.2 MB and a Microsoft Data Engine component is 22.5 MB.

Some tuning in the service pack is specifically for the greater-than-eight-processor machines provided by Unisys Corp., Ressler says. The issue was documented several months ago when SQL Server 2000 achieved certified application status in the Windows 2000 Datacenter Server 2000 certification program. (See story).

The final code for the service pack was posted on Microsoft's TechNet Web site earlier this week, and on Microsoft's SQL Server page late Wednesday.

However, full descriptions for many of the fixes included in SP1 aren't expected to be posted on the site until Monday, Ressler said.