FIX: The results of the query may be returned much slower than you expect when you run a query that includes a GROUP BY statement in SQL Server 2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;900404
BUG: Queries against indexed views may run slower when you install a SQL Server 2000 post-SP3 hotfix, a SQL Server 2000 post-SP3a hotfix, or SQL Server 2000 SP4
http://support.microsoft.com/default.aspx?scid=kb;en-us;906117
FIX: You receive a "Getting registry information" message when you run the Sqldiag.exe utility after you install SQL Server 2000 SP4
http://support.microsoft.com/default.aspx?scid=kb;en-us;902955